I have a master list of accounts on my hard drive. Our staff assistant sends
a new updated spreadsheet with new adds or changes. I also make changes on my
master list that are not on the new-updated list sent to me. How do I update
my master list from the new updated spreadsheet I get weekly? Been trying
help menus galore and can't figure it out. By the way, we do not have a
shared drive to dynamically update the master. Thanks for any help.

The best way is to write a macro using the account IDs to identify each row.
The macro will compare IDs in one workbook with the same IDs in the 2nd
workbook. Each row in the assistant workbook will be compared against the
Master. When the ID doesn't appear the row will be copied to the Master
workbook. When the IDs match the assistants data will be copied over the
Master data. Hopefully the assistants data is correct when it gets copied,
otherwise, good data will become bad data. Some people prefer to just
highlight changes and then manually make the corrections. New row can be
automatically copied and highlighted so the can be chaecked.

There are two problems with your description

1) What happens when a line get deleted
2) How do you prevent you and your assistants making different changes to
the same ID.

"Boinks" wrote:

I have a master list of accounts on my hard drive. Our staff assistant sends
a new updated spreadsheet with new adds or changes. I also make changes on my
master list that are not on the new-updated list sent to me. How do I update
my master list from the new updated spreadsheet I get weekly? Been trying
help menus galore and can't figure it out. By the way, we do not have a
shared drive to dynamically update the master. Thanks for any help.