Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
match, copy, paste, & color
Hi,
This requires 2 steps. First put this in D1 and drag down as required =IF(ISNA(VLOOKUP(A1,'Union Contract'!A1:F39,6,FALSE)),"",VLOOKUP(A1,'Union Contract'!A1:F39,6,FALSE)) Select the cells woth your formula in and then Format|Conditional format Cell values - Greater than and enter "" Note there is no space between the quotes Pick a colour Mike "Stephen" wrote: 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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
match, copy, paste, & color
hmmm. i see where this is going but I think i need to lookup the value in my
"Rate Check" column A, as the columns is populated with it's own VLOOKUP and I think your VLOOKUP is seeing the formula instead of the value. "Mike H" wrote: Hi, This requires 2 steps. First put this in D1 and drag down as required =IF(ISNA(VLOOKUP(A1,'Union Contract'!A1:F39,6,FALSE)),"",VLOOKUP(A1,'Union Contract'!A1:F39,6,FALSE)) Select the cells woth your formula in and then Format|Conditional format Cell values - Greater than and enter "" Note there is no space between the quotes Pick a colour Mike "Stephen" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy color text & paste keeping color | Excel Discussion (Misc queries) | |||
Match , copy paste (using find?) | Excel Programming | |||
Compare col and match then copy and paste | Excel Discussion (Misc queries) | |||
help with match, copy, paste please | Excel Programming | |||
How copy format, font, color and border without copy/paste? | Excel Programming |