| Home |
| Search |
| Today's Posts |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
summary sheet that refers to multiple sheets
Did you ever get this to work, I read through the answer and tried the
different but it did not work I have 2 sheets-NY AND LA A1:I1 ON BOTH SHEETS ARE THE SAME AND ABOUT 1000 ROWS STARTING ON A2:I2 OF DATA ON EACH SHEET BUT OF COURSE DIFFERENT HELP!!!!!!!!!!MY BOSS IS ON VACATION AND I TOLD HIM I WOULD HAVE IT FOR HIM NEXT MONDAY -- Thanks again, Herz and His "TBA" wrote: We are trying to produce a summary sheet that displays the value of the same cell from a range of sheets. Ideally it will be a formula that can be copied down the column, with each cell incrementing to the next sheet. possible solutions might be around the use of a reference list to change the sheet reference within the formula?apologies if this makes no sense! happy to elaborate further |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LINKING MAIN SHEET WITH MULTIPLE SUMMARY SHEETS | Excel Worksheet Functions | |||
| Summary Sheet - Total Multiple Sheets | Excel Discussion (Misc queries) | |||
| Summary Sheet help with multiple sheets | Excel Discussion (Misc queries) | |||
| Linking References from Multiple Sheets to One Summary Sheet | Setting up and Configuration of Excel | |||
| linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
Threaded Mode
