Ex: I want to link a set of data from A1:A5 from sheet 1 to sheet 2. But the set of data can change and it might be from A1:A6 or A1:A7 etc. etc. I want those changes to automatically show in sheet 2 without having to link again. Is that possible?? Thanks.
Last edited by jaganath; 04-01-2010 at 05:56 PM.
Could you be more clear about what you mean by linking? Do you mean referencing the range in a formula on sheet2? If so, create a dynamic named range and use the name in place of the hard-coded reference.
Example:
If we define a dynamic named range as "MyRange" using this formula:
We could reference (i.e. "link") it to a formula in sheet2 such as:=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1)
=SUM(MyRange)
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
Sorry I wasn't more clear but yes I mean referencing the range in a formula on sheet2. Your answer is perfect thanks.
Glad to be of help.
Please mark your thread as solved by going to your first post and clicking on Thread Tools, the Go Advanced and choose the [SOLVED] prefix. Thanks.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
actually I didn't want to sum the numbers, I just wanted to copy them over to sheet 2. I named the range of numbers in sheet one I want to copy over as "Numbers" how would I copy that range over to sheet 2? hopefully that is clear. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks