View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kris kris is offline
external usenet poster
 
Posts: 128
Default 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