PDA

View Full Version : Linking cells from separate *.xls files into a Workbook



itipu
01-14-2008, 04:26 AM
Hi all, an interesting problem here... I have attached a sample.

At the moment I have a worksheet called "Project X" with lots of data in it. And on the "Summary Sheet" I simply fill-in a template linking to "Project X" sheet cells.

All templates and linked cells will always be the same!!!

Now what I would like to have: I want to keep "Project X" as a separate ProjectX.xls file, and I will also have ProjectY.xls and ProjectZ.xls and so on... all in the same folder... Now lets say in my SummarySheet.xls I would have a button (i can do that no problem) which I would click and my template will be populated automatically with data from these *.xls files found in the folder... 1 row per file.... (This I am not sure how to do)

But it is quite interesting! Would greatly appreciate your suggestions!


Thanks a lot

Mike