I'm wondering if it's possible in Excel to call data from a different sheet.
For example if I changed A1 in sheet 2 it'd affect forumlas in sheet 1.
I'm wondering if it's possible in Excel to call data from a different sheet.
For example if I changed A1 in sheet 2 it'd affect forumlas in sheet 1.
You can link to another worksheet with a formula like
='Sheet1'!A1
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"HisHighness"
<[email protected]> wrote
in message
news:[email protected]...
>
> I'm wondering if it's possible in Excel to call data from a
> different
> sheet.
>
> For example if I changed A1 in sheet 2 it'd affect forumlas in
> sheet 1.
>
>
> --
> HisHighness
> ------------------------------------------------------------------------
> HisHighness's Profile:
> http://www.excelforum.com/member.php...o&userid=31454
> View this thread:
> http://www.excelforum.com/showthread...hreadid=511552
>
HisHighness, if the formula is looking at sheet2 cell A1 it will, if this is
in sheet 1 it will change when you change sheet 2 cell A1
=Sheet2!A1
Does this help? if not explain a little more what you want to do
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"HisHighness" <[email protected]>
wrote in message
news:[email protected]...
>
> I'm wondering if it's possible in Excel to call data from a different
> sheet.
>
> For example if I changed A1 in sheet 2 it'd affect forumlas in sheet 1.
>
>
> --
> HisHighness
> ------------------------------------------------------------------------
> HisHighness's Profile:
http://www.excelforum.com/member.php...o&userid=31454
> View this thread: http://www.excelforum.com/showthread...hreadid=511552
>
Nope that's exactly what I needed. Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks