I have two work books. One is "historical" data and the other is "update"
data for records in the first. I want to program some vb to update
"historical" with the "update" data. Also I would not be using all the data
in the whole row. I will only be updating certain columns of a row to
historical:

Column A in both is the account number. The script should take each account
number in "update" and match it to the account number in historical, if there
is a match it should update columns B, E, M, O of historical with update. If
there is no match it should add a new record and update the same columns.

Also this code should be contained in historical, also I need a way to
activate rows in historical to show active records, what I mean by active is
only records that were updated or added should be active. In other words
maybe add another column called active to historical and as the script runs
it puts the word active in a column or deactive in the same column and then I
could filter it to show only the active ones. Im not sure if there is a
better way of doing that or not, but i do not know how to code my thought
either. Thanks so much in advance.