MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Linking 50 files

Posted by Peter on July 02, 2001 12:53 AM

I need to create a master spreadsheet that will have fifty separate worksheets attached to it. I want to create a validation list on top of each row with the 50 spreadsheet names and once selected, the linked formula in each column will recognise the selected validation list name and link to that file (the cell references will remain unchanged, just the destination file will change). I hope this makes sense and can anybody help.

Also how do I make the Save As dialog box appear with the File Name the same as a selected cell.


Posted by Connie on July 02, 2001 6:16 AM

I had a similar question involving hyperlinks and drop-down lists. Check out my question and subsequent answer and see if it helps you: