koala
10-13-2010, 06:36 AM
Hi Forum.
I have two worksheets, Data and Output. Both sheets are identical in size. Workarea is column I:AV, however row length can alter - generally approx 1000 rows. Data has value in every cell, however Output only has values in some cells.
Both sheets have header in I2:AV2, and Date in A3:A
All values are text.
I need to check every cell in I:AV of Data, and if value "XYZ" (capital letters XYZ) are found, check same cell in Output, and if value "m" (small letter m) is found, change "m" to "Y" (captial letter Y).
To summarise: (assume checking cell I5)
If Data I5 = "XYZ", and Output I5 = "m", change Output I5 to "Y"
If Data I5 = "XYZ", and Output I5 <> "m", do nothing, keep checking cells
If Data I5 <> "XYZ", do nothing, keep checking cellsI have attached a sample workbook, with a sheet titled Amended Output which shows the Output I desire. (hightlighted in RED).
Thanks in advance
Koala
I have two worksheets, Data and Output. Both sheets are identical in size. Workarea is column I:AV, however row length can alter - generally approx 1000 rows. Data has value in every cell, however Output only has values in some cells.
Both sheets have header in I2:AV2, and Date in A3:A
All values are text.
I need to check every cell in I:AV of Data, and if value "XYZ" (capital letters XYZ) are found, check same cell in Output, and if value "m" (small letter m) is found, change "m" to "Y" (captial letter Y).
To summarise: (assume checking cell I5)
If Data I5 = "XYZ", and Output I5 = "m", change Output I5 to "Y"
If Data I5 = "XYZ", and Output I5 <> "m", do nothing, keep checking cells
If Data I5 <> "XYZ", do nothing, keep checking cellsI have attached a sample workbook, with a sheet titled Amended Output which shows the Output I desire. (hightlighted in RED).
Thanks in advance
Koala