Hi all,
I have a Workbook that I have created with a Summary page to view with data filed from all sheets in the work book, but just certain cells. My question is, without having to reference each cell manually, is there a way to copy from the "template" Sheet to the remaining 20 odd sheets?
Then if I create an new sheet, how do I get it referenced in the Summary sheet.
I have attached the file for reference.
Cheers,
Try typing
=INDIRECT("'Template (" & CELL("row",A2) & ")'!$B$1")
into A2 on the summary sheet and copying down.
Note that for this to work, the sheet Template needs to be renamed as Template (1).
Do similar for the other columns. If a new sheet is added, you should be able to copy down the last row one more row for it to be picked up.
Martin
Perfect thank you!
However, next issue is if I rename the Tab's to reflect a name this will no longer work will it? Is there a workaround for that?
Perfect thank you!
However, next issue is if I rename the Tab's to reflect a name this will no longer work will it? Is there a workaround for that?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks