M
mr_teacher
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
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