smittycft99
Board Regular
- Joined
- Apr 16, 2002
- Messages
- 128
Sorry in advance for the remedial question:
I want to create a master.xls with tabs for each site I have (Site 1, Site 2, Site 3, ect), where each tab represents all the contents of the Site.xls (1 worksheet only).
Whenever I update the Site 1.xls or the Site 2.xls, it will update the respective contents of the master.xls file.
I am able to do this: =IF('[Site1.xls]Site 1'!A1="","",'[Site1.xls]Site 1'!A1) , but what I'm looking for is - can I set it up to update both ways? What I mean is - if I update the Site 1.xls it will update the Master.xls, or if I update the Master.xls it will reflect on the Site 1.xls?
Thank you very much for all your help.
PS> I searched the archives and couldn't find an answer and I have Excel 2003
I want to create a master.xls with tabs for each site I have (Site 1, Site 2, Site 3, ect), where each tab represents all the contents of the Site.xls (1 worksheet only).
Whenever I update the Site 1.xls or the Site 2.xls, it will update the respective contents of the master.xls file.
I am able to do this: =IF('[Site1.xls]Site 1'!A1="","",'[Site1.xls]Site 1'!A1) , but what I'm looking for is - can I set it up to update both ways? What I mean is - if I update the Site 1.xls it will update the Master.xls, or if I update the Master.xls it will reflect on the Site 1.xls?
Thank you very much for all your help.
PS> I searched the archives and couldn't find an answer and I have Excel 2003