Consulting

Results 1 to 3 of 3

Thread: Find and copare value afte fill cell

  1. #1

    Find and copare value afte fill cell

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

  2. #2

  3. #3

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •