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!
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!