Ok, had a look at the help for that and I think I can get the general
gist of it so will have a play around with it.

Can this be used to reference data though that is on a different
worksheet? I basically have 36 different small spreadsheets in various
places within the same workbook and I want to be able to call on data
from any of these 36 tables and reference them in one table that will
display the results?

Ideally I would be able to reference the named range in my results
spreadsheet (through drop down selection lists to choose the correct
data)and this would call up and display the data from the source
table.

Not sure if that is making any sense now or not though! Hope it does

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=564849