Simple VBA with explainations

profilewilsonk

  

2 Excel files (Sample master list and sample data)

Using VBA.

Filter sample data column C to see if it matches Sample master list column C

If both column C matches, copy data column E from sample data to sample master list column E

File location for both files: C:\Users\zhihw\Desktop\Wilson Test

Please provide explanation next to the codes.

Done immediately.

Thank you

  • 8 years ago
  • 15
Answer(1)

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    SampleMasterList9.xlsm
  • attachment
    SampleData12.xlsx