Hello everybody! I posted a question earlier and figured I'd put an
example in to clarify what I'm seeking help for.

Here's a sample set of data - the comma's signify delimited data
(different columns.)


I have row headings strarting in A1 and they go to A5.
First row of data starts in A2. (Please note below data is just dummy
data)


Transaction Number, Company, Date, City, Status
Accntg-123-01,Alpha Corp,20070101,New York,New Data
Accntg-123-02,Beta Corp,20070508,New Jersey,New Data
Accntg-235-01,Gamma Corp,20070301,Delaware,New Data
Accntg-163-01,Delta Corp,20070101,New Haven,New Data
Accntg-175-01,Espsilon Corp,20071101,Newark,New Data


OK, the worksheet contains more data and columns, but above is done
only for the sake of example. Now, here's the problem. I input 3 more
rows of data starting at the next available cell in column A. This
data represents updates to entries above - here's the example:


Accntg-235-01,Gamma-C Corp,20075601,Delaware,New Data
Accntg-123-01,AlphaDog Corp,20072115,New York,New Data
Accntg-163-01,Delta Blues Corp,20070105,New Haven,New Data


As you can see, column A above is similar to 3 entries in the
original
data - so, once these entries are recorded, I want to press a button
to run a macro, which would compare the latest entries with the
previous entries by looking at column A and if there's a match above,
then column E should be changed from "New Data" to "Old Data" -
here's
what it should look like after i run the macro:


Transaction Number, Company, Date, City, Status
Accntg-123-01,Alpha Corp,20070101,New York,Old Data
Accntg-123-02,Beta Corp,20070508,New Jersey,New Data
Accntg-235-01,Gamma Corp,20070301,Delaware,Old Data
Accntg-163-01,Delta Corp,20070101,New Haven,Old Data
Accntg-175-01,Espsilon Corp,20071101,Newark,New Data
Accntg-235-01,Gamma-C Corp,20075601,Delaware,New Data
Accntg-123-01,AlphaDog Corp,20072115,New York,New Data
Accntg-163-01,Delta Blues Corp,20070105,New Haven,New Data


As you can see, the first entry in cell A2 matches A8, which is the
latest transaction, so cell E2 gets changed from "New Data" to "Old
Data." So, whenever i run this macro, the latest entries (at the
bottom of the data) represents new data and compares contents of
whatever is in A with that above and if there's a match above it, the
entries in column E gets updates from "New Data" to "Old Data."


I hope this was clear - please let me know if you need anything
further.


Thanks,


Tim

See request for clarification in response to previous posting of this
question.

--
Regards,
Tom Ogilvy

" wrote:

Hello everybody! I posted a question earlier and figured I'd put an
example in to clarify what I'm seeking help for.

Here's a sample set of data - the comma's signify delimited data
(different columns.)


I have row headings strarting in A1 and they go to A5.
First row of data starts in A2. (Please note below data is just dummy
data)


Transaction Number, Company, Date, City, Status
Accntg-123-01,Alpha Corp,20070101,New York,New Data
Accntg-123-02,Beta Corp,20070508,New Jersey,New Data
Accntg-235-01,Gamma Corp,20070301,Delaware,New Data
Accntg-163-01,Delta Corp,20070101,New Haven,New Data
Accntg-175-01,Espsilon Corp,20071101,Newark,New Data


OK, the worksheet contains more data and columns, but above is done
only for the sake of example. Now, here's the problem. I input 3 more
rows of data starting at the next available cell in column A. This
data represents updates to entries above - here's the example:


Accntg-235-01,Gamma-C Corp,20075601,Delaware,New Data
Accntg-123-01,AlphaDog Corp,20072115,New York,New Data
Accntg-163-01,Delta Blues Corp,20070105,New Haven,New Data


As you can see, column A above is similar to 3 entries in the
original
data - so, once these entries are recorded, I want to press a button
to run a macro, which would compare the latest entries with the
previous entries by looking at column A and if there's a match above,
then column E should be changed from "New Data" to "Old Data" -
here's
what it should look like after i run the macro:


Transaction Number, Company, Date, City, Status
Accntg-123-01,Alpha Corp,20070101,New York,Old Data
Accntg-123-02,Beta Corp,20070508,New Jersey,New Data
Accntg-235-01,Gamma Corp,20070301,Delaware,Old Data
Accntg-163-01,Delta Corp,20070101,New Haven,Old Data
Accntg-175-01,Espsilon Corp,20071101,Newark,New Data
Accntg-235-01,Gamma-C Corp,20075601,Delaware,New Data
Accntg-123-01,AlphaDog Corp,20072115,New York,New Data
Accntg-163-01,Delta Blues Corp,20070105,New Haven,New Data


As you can see, the first entry in cell A2 matches A8, which is the
latest transaction, so cell E2 gets changed from "New Data" to "Old
Data." So, whenever i run this macro, the latest entries (at the
bottom of the data) represents new data and compares contents of
whatever is in A with that above and if there's a match above it, the
entries in column E gets updates from "New Data" to "Old Data."


I hope this was clear - please let me know if you need anything
further.


Thanks,


Tim