Link multiple spreadsheets to one central spreadsheet using a macro

  • Thread starter Thread starter Amanda
  • Start date Start date
A

Amanda

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!
 
Hi Amanda;

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

Thanks,

Greg
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top