Using code to mimic a find and replace
Hi,
I have two worksheets, one holds data horizontally for course codes,
vertivcally for peoples names, the cells have a y or N to indicate if the
course is requred, the second sheet holds the same data drawn from a database
with the addition of a date (i.e if the peson has attended the course) This
first sheet is regularly refreshed.
I would like to be able to take the date from the first sheet and find the
same person and code on the second sheet and replace if a y is present with
the date, if the y is not present then replace with the date and change the
cell colour.
|