I have reference data in columns A and B on Sheet2 of my WorkBook
. I have a blank sheet - Sheet1 - which i need to fill from my database.
I want to use Excel VBA to fill Sheet1 based on data in columns A and B in Sheet2.
I use the reference data by.
- I populate values in column A in Sheet1 from DB.
- I check if the values stored in sheet 1, column A exist in Sheet2 column A,
- If so, I populate into sheet 1 column B, the corresponding data i've found in Sheet2 column B.