Simple VBA with explainations

wilsonk

  

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

NOT RATED
  • SampleMasterList9.xlsm
  • SampleData12.xlsx