PDA

View Full Version : [SOLVED] Find and copare value afte fill cell



elsg
09-28-2014, 09:06 AM
I need copare values column A in sheet("Org") with cell A23 in sheet("NET"), case equal, get value in cell A22 ->LEFT(NET!$A$22;7) and fill adjacent cell column A sheet("Org")

how make it any moment cells change values (using worksheet_change)
Look my file attachment.

Ex: B and C and D need filled.

After code run (Result in sheet("Org")....A20=11,0550, B20=5,8648, C20=7,8808.)

Part I.
In A20 sheet("Org") has date 30/09/2014, is equal A23 in sheet("NET"), then in B20 sheet("Org"), receive A22 in sheet("NET") value cell.
Part II.
In A20 sheet("Org") has date 30/09/2014, is equal A9 in sheet("NET"), then in C20 sheet("Org"), receive A7 in sheet("NET") value cell.

Part III.
In A20 sheet("Org") has date 30/09/2014, is equal A9 in sheet("NET"), then in D20 sheet("Org"), receive A8 in sheet("NET") value cell.

Thank you!

elsg
09-29-2014, 09:09 AM
....
Cross-Post
http://www.excelforum.com/excel-programming-vba-macros/1040181-find-and-copare-value-afte-fill-cell.html#post3849839

elsg
09-30-2014, 10:21 AM
Solved in
http://www.excelforum.com/excel-programming-vba-macros/1040181-find-and-compare-value-after-filling-cell.html