Copy worksheet from one workbook to a master workbook


M

mvannatta

I have a master workbook that has multiple worksheets. each worksheet has a
companion workbook. Currently, I open the companion workbook and manually
copy from workbook to workbook. Is there a way to create VBA process or
series of macros to open each companion workbook and copy the worksheet to
the master? Each companion workbook only has one worksheet, same name as the
workbook
 
Ad

Advertisements

Ad

Advertisements


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

Top