How to Drag formulas across a summary page that refers to different Sheets????
I have a number of Sheets that refer to different Locations say "Birmingham","London","Bristol". each of these sheets is formatted exactly the same with the same information but different values.
I have various formulas that pull the relevant information from one sheet to the front summary sheet, how can I make it so that when I drag the formulas across it represents a different sheets ie: column one is all the Birmingham values, column 2 is all the London values?
Thankyou in advance
Have a look at the attached. INDIRECT is your friend here.
If I've been of help, please hit the star
Thankyou Spencer just what I needed! ive come across this one as well =INDIRECT(ADDRESS(14,9,,,C$7)), it appears to just be a long winded way of doing it, is that fair to say?
Thanks again
Without seeing the example that the =INDIRECT(ADDRESS.... example comes from, I couldn't say why that approach had been taken.
My initial thought would be, you're right and it's just a drawn out way of doing the same thing.
Glad you have your solution though.
Too True, sometimes less is more!!
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks