rollingzep
Board Regular
- Joined
- Nov 18, 2013
- Messages
- 214
- Office Version
- 365
- Platform
- Windows
I have two sheets on the same WB.
WS, Original contains CUS_ID and MARKET_DES. WS, Test contains few fields like product, and MARKET_DES
I need product from Test to look up the values of CUS_ID of Original and fill the ST field in MARKET_DES with the values of MARKET_DESC from Original.
I am looking to do this using Excel VBA since I have other code for other functionalities.
I have pasted a sample of data.
I downloaded XL2BB but was unable to add it as ADD-IN on my work laptop
WS, Original contains CUS_ID and MARKET_DES. WS, Test contains few fields like product, and MARKET_DES
I need product from Test to look up the values of CUS_ID of Original and fill the ST field in MARKET_DES with the values of MARKET_DESC from Original.
I am looking to do this using Excel VBA since I have other code for other functionalities.
I have pasted a sample of data.
I downloaded XL2BB but was unable to add it as ADD-IN on my work laptop