View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stephen[_24_] Stephen[_24_] is offline
external usenet poster
 
Posts: 83
Default match, copy, paste, & color

Hi Folks,

I'm working with two sheets, "Rate Check" & "Union Contract Raise Report".
With "Rate Check" column A I want to find the matching value in "Union
Contract Raise Report" column A, copy the given rows value from "Union
Contract Raise Report" column F, paste the value into "Rate Check" column D
for that row, then format the new column D value Blue so the user knows it
has been changed.

If there is no matching value between "Rate Check" & "Union Contract Raise
Report" for a given row, then simply move on to the next row until the end is
reached.

Any help is always greatly appreciated.

TIA!