From: Eric on
I am trying to make a macro that will match 3 criterias and replace in
formation with in that row.

The rows consist of 25 columns and I need to replace the information in
columns g through f and keeping all other columns the same.

the 3 criterias are Date, Job, Plant
A B C D.....
1 5/5/10 567 NB 1500

60 5/5/10 567 NB 3000

In this example I need to replace row 1 with row 60 because the information
in column D through column J is different.

Is this possible? Any help would be appreciated.
Thank you