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

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

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