Link multiple spreadsheets to one central spreadsheet using a macro

Link multiple spreadsheets to one central spreadsheet using a macro

Post by Amand » Fri, 20 Aug 2004 04:38:04


Is it possible to write a macro using visual basic editor
for applications that will search for all files within
one file folder, automatically create canned links to the
same cells within each file and return or update the data
to one central excel file. Each new row would have links
to the same cell numbers but different file names.

Please help!
 
 
 

Link multiple spreadsheets to one central spreadsheet using a macro

Post by GJone » Fri, 20 Aug 2004 05:59:29

Hi Amanda;

It is possible to do what your asking about but it most
likely a consulting job.

Thanks,

Greg
XXXX@XXXXX.COM