How to update a Master worksheet with a working copy.

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
 
B

BrianB

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
 
Top