Hi all,

Why can the boss never work in a vertical world?

-"Can you copy, paste & transpose each row in these two worksheets and
then highlight the changes for me?" the boss asks...-

Sheet1 is my baseline, containing approximately 1582 rows of data; 215
columns. Sheet2 is a newer version, 2 months later.

-"I will need you to do this every two months" the boss goes on,
ignoring the evil eye i directed her way.-

I've said my prayers, rubbed my magic eight ball, and am checking with
the experts here to see if this can be done with VBA, looping through
the rows and comparing data to see where updates have occurred, hoping
that I don't end up in copy/paste/cond-form purgatory...

In order for each row to be considered for compare between the
worksheets, the values in the A, B, C, D & H cells will need to be an
exact match (they will be unique values and will occur within both
worksheets).

Once a row from the baseline identifies a match row, I would like to
have the cell background formatted in pink.

Example, row 2 from Sheet2 "matches" row 1321 of Sheet1 (based on the
above matching logic), and the data in AB2, AD2, BR2, CI2 & CX2 has
changed on Sheet2 from the data as found in Sheet1.

Thank you for your time ~


--
Trixie

~TRIXIE
------------------------------------------------------------------------
Trixie's Profile: http://www.thecodecage.com/forumz/member.php?userid=438
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=148967