View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andrew W Andrew W is offline
external usenet poster
 
Posts: 3
Default Referencing cells in multiple worksheets

I have a file with multiple worksheets (up to 50 in a file). The worksheets
have different names but contain data in the same locations and format as
each other.

What I want to do is create a table on a worksheet that copies a specific
cell from each worksheet that I can then sort.

Example:

4 worksheets called: Adam, Dave, Pete, Mike
I want to produce a table showing cell B2 from each of the above sheets to
look something like:

Sheet B2 Value
Dave 12
Pete 4
Mike 38
Adam 24

I would like to be able to do this without using a macro if possible. Can
anyone help???

Thanks