I was wondering if it's possible to manually choose a specific lookup table from another workbook by typing the table name into a dedicated cell?
I'd like to be able to type the table name into cell A1 (or use a drop-down menu) and choose a specific table to use as the data reference for another group of cells.
For example, typing in, or selecting from drop-down "Costs2005" (or "Costs2004", etc.) selects that table to be used for cells B2:D10.
Thanks for any insights