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