Hello Excellers,
I have one spreadsheet sourcing data from another. I would like extra rows of data in my source spreadsheet updated in the destination spreadsheet. I'm using the = command to link a range of cells, and that range needs to change as extra rows are added in the source file.
I've seen another persons query regarding my problem here: "need to link external worksheet", and the solutions provided aren't quite what I'm looking for (solutions involving copying the entire tab). So I was wondering if there was any new thinking on this?
Happy day to you all!
... if you could be a bit more specific about what you are looking for? Maybe supply a sample source sheet and a sample target sheet with manually mocked up results, explaining the logic how you would Excel want to arrive at these results?aren't quite what I'm looking for
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking theicon below the post.
Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks