Checking a database/excel sheet for new entries
 

Hello everybody,

I was wondering if i can get some help with a problem i have. I
currently have a worksheet in Excel which holds monthly transaction
information for my company. What I normally do is copy transaction
info from another program and paste it into the next available cell
(starting in column A) in Excel. There are 43 columns/fields in this
worksheet. So here's what I need:


Once I copy in the information to the next available cell, i want to
be able to run a macro which would compare the contents (transaction
numbers) in column A
(e.g. A160) with the rest of the entries (A1:A159) - if there is a
match in the transaction number, I'd like Excel to put in "Old
transaction" in the corresponding cell in column AQ (the 43rd column).
I already automatically put in "New transaction" for any new entries
but i need to update any and all previous matching transaction numbers
with "old transaction" into AQ. Please
note that I copy and paste up to 8 rows of data into the worksheet
before running the macro. All i need is the logic to compare whatever
I pasted in last (up to 8 entries) with what ever was in the
worksheet
before. Thanks for any and all efforts to help.


Tim