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
 
Back
Top