Hi there,
Lets assume 100 sheets. 99 Data and 1 Master.
Lets assume all cells located in the same subdirectory /test/results
In the master I require an extract (ie results of certain cell refs)
from the 99 data sheets. It can be a one time extraction, ie does not
need to be linked.
Lets say I require Cells b1,c2 and d3 in the master
Is there any VB that I could write that would go to the sheet copy the
data and paste it into the Master sheet
(perhaps even without opening the workbook)
I appreciate any guidance...
Thanks
D
*** Sent via Developersdex http://www.developersdex.com ***
Bookmarks