| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summary worksheet referencing 100 worksheets
I have a summary worksheet with a table of data that references the same
cells in about 100 worksheets. Is there a way to reference the worksheets by other than worksheet name, e.g. by a number in the order that they appear in the workbook? This would save having to add the worksheet name to each of several cells in the list. Thanks, Kris |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Summary worksheet referencing 100 worksheets
Hi Kris
No, you need the name in the link You can use this macro to create the links for you if you want http://www.rondebruin.nl/summary.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Kris" wrote in message ... I have a summary worksheet with a table of data that references the same cells in about 100 worksheets. Is there a way to reference the worksheets by other than worksheet name, e.g. by a number in the order that they appear in the workbook? This would save having to add the worksheet name to each of several cells in the list. Thanks, Kris |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Summary worksheet referencing 100 worksheets
Thanks Ron
"Ron de Bruin" wrote: Hi Kris No, you need the name in the link You can use this macro to create the links for you if you want http://www.rondebruin.nl/summary.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Kris" wrote in message ... I have a summary worksheet with a table of data that references the same cells in about 100 worksheets. Is there a way to reference the worksheets by other than worksheet name, e.g. by a number in the order that they appear in the workbook? This would save having to add the worksheet name to each of several cells in the list. Thanks, Kris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine two worksheets into one summary worksheet | New Users to Excel | |||
| Combine 6 worksheets into 1 worksheet - Summary | Excel Discussion (Misc queries) | |||
| Linking Worksheets to a Summary Worksheet | Excel Worksheet Functions | |||
| Spawning worksheets and a summary per worksheet | Excel Discussion (Misc queries) | |||
| Summary worksheet referencing multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
