I would like to request Experts help to modify module 1 and 2 in the “Listing” workbook. Currently Module 1 and 2 Module copy data from Listing Workbook to MasterData workbook. The problem is Data at Column E (MasterData WB) was not updated according to Module selection.
If data gets updated by using “Out” sheet (Listing), Column E at MasterData need to be captured as “StoreA”. If using “IN” Sheet, Column E at MasterData workbook need to capture as “StroreB”. Hope Experts can help me to modify this script. Attached the workbook for Experts perusal.