Link multiple spreadsheets to one central spreadsheet using a macro
 

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
 

Hi Amanda;

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

Thanks,

Greg



-----Original Message-----
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!
.