From: Eric on 17 May 2010 11:53
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.