Looking up data from several spreadsheets
 

Hi all,

I am pretty sure this has been answered before - seem to remember there
were a lot of answers to it too but I can't find the thread anywhere -
could be me being really unobservant though!

I am trying to have data automatically put into a spreadsheet from
several other spreadsheets (36) that are located in different
workbooks. All the spreadsheets are identical in size but have
different info. What I would like to be able to do is to select a
certain spreadsheet from a drop down list and my results spreadsheet
would be able to find the correct info. I have given each spreadsheet a
name so I can refer this.

If I remember rightly there was a bit of debate as to whether it was
better to use VLOOKUP or the OFFSET command to do something similar?

Any help that can be offered or a link to that thread would be really
appreciated! Hope my description makes some sense too!

Thanks a lot

Carl


--
mr_teacher
------------------------------------------------------------------------
mr_teacher's Profile: http://www.excelforum.com/member.php...o&userid=34352
View this thread: http://www.excelforum.com/showthread...hreadid=564770