A way to link multiple workbooks to one

  • Thread starter Thread starter poemagic
  • Start date Start date
P

poemagic

I have been tasked with linking about 30 workbooks with 1 worksheet
each to one master workbook. We work different shifts and they want to
be able to get the data even if someone isn't here. Currently we are
copying and pasting the data. I was going to do a macro until they
told me about getting the data from a closed workbook. I haven't done
VB in years so I am quite stuck, any help is greatly appreciated. I
have already tried to convince them to use access and then I could
just do a sql script for them to do the reports but that didn't work.
 
You must log in or register to reply here.

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

Similar Threads

Pulling data from one workbook to another one using VBA 0
Who is linking to my file? And what files am I linking to? 1
Import multiple workbooks to current workbook in specified row number 0
Excel Protection 2
one workbook, multiple users.... 2
Merge Multiple workbook sheets into one workbook 0
Collate data from multiple workbooks into one worksheet 0
Copy data into multiple workbooks 1

Back
Top