| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pulling data from Sheets in A workbook
I have 100 sheets with the same layout that I want to summarize on a master
worksheet. The cell references are the same on all 100 sheets so it is easy to link the data but I dont want to reference or change the sheet name to get each line of data. Can I name the sheet with a text string that is on my summary worksheet and have a formula look for that sheet and pull the data in the referenced cells. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling data from other Excel sheets | Excel Discussion (Misc queries) | |||
| Need help with a formula pulling data from mutilple sheets | Excel Discussion (Misc queries) | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| pulling through data from another workbook | Excel Discussion (Misc queries) | |||
| Pulling data from another workbook | Excel Worksheet Functions | |||
Threaded Mode
