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
 

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

Sub projects added as read only in Master file which are saved on sharepoint 1
How to update data entry to a linked worksheet and then return thenew value back to a master workshe 0
Syncing Master Project in Sharepoint 0
Embed the same Excel multiple times 0
External cell reference between two excel worksheets both in One Drive 0
How to update a value from a linked worksheet back to the master worksheet? 0
How to update data from linked worksheet back to a master worksheet? 0
Excel linking from one master worksheet to many worksheets and ableto return a value back. 0

Top