#1
|
|||
|
|||
Referencing different sheets
Hello.
I have a workbook with a LOT of sheets, labeled as dates(3-1-16, 3-2-16 ect.) I have a master sheet that is pulling a specific cell from each sheet. I need to be able to do something to automate the ever updating sheets, like right now each cell of the master sheet is something like ='3-1-16'!b$1' and each line I am typing in the name of the sheet each time. I need to be able to do like 1000 of these quickly and not have to copy down the ='3-1-16'!b$1' for the thousand and change each one to be the correct sheet name(date). Any ideas? Thanks! |
#2
|
|||
|
|||
Maybe like this.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to manage some sheets and sub-sheets? | tesoke | Excel | 6 | 11-15-2015 04:54 AM |
Referencing | darksupernova | Word | 4 | 11-08-2012 03:37 AM |
Multiple referencing | SPRITEtoo | Word | 3 | 01-29-2012 07:39 PM |
Linking sheets to fetch transactions from sheets to another | waqer | Excel | 4 | 09-01-2011 12:35 PM |
Cross referencing | maltesedog | Word | 0 | 02-13-2009 07:43 AM |