Hi All!
I wish to dynamically upate a target workbook with references to a large number of source workbooks without having all the source workbooks open on my local PC. I have people on the phones working on anything up to 25 separate workbooks. I have created a target spreadsheet that functions as a dashboard and allows me to monitor “live” any changes made in any these workbooks. Most of my formulae are “COUNTIF” style formulae using “INDIRECT” and they work because all the source workbooks are shared and open on my local PC. In order to refresh the counts on my dashboard I have a macro that saves all open workbooks. How can I dynamically reference my source workbooks without them all being open on my local PC? Please note that some of the source workbooks might be closed but the majority will be open by other users.
Thanks in advance.
Regards
Itzik
Bookmarks