How to update a Master worksheet with a working copy.

  • Thread starter Thread starter Emml
  • Start date Start date
E

Emml

How to update a Master worksheet with a working copy.
First column for both worksheets are same. The master copy
is very large so I created another small copy to work on
and update the Master periodically but I can seem to link
both workbooks to update the changes made from my working
copy
HELP
Thanks
 
1. Insert an empty column in the Master and use VLOOKUP() to transfe
values. Delete the original column.

2. Write a macro which runs through the copy picking up column1 dat
and using Find in the Master
 
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

Copy worksheet from one workbook to a master workbook 2
Automatically copy from Master worksheet to others 3
Lookups - how to obtain data from a master spreadsheet into another 5
Linking data from one worksheet to another... 2
linking worksheets to a closed workbook 2
Using a Master Worksheet 1
Can I copy my protection settings from 1 workbook to another? 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0

Back
Top