Summary worksheet referencing 100 worksheets

[Kris]

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

 

[Ron de Bruin]

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

 

[Kris]

Thanks Ron

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