Hi,
My requirement:
1.) Import 3 files (ECC-Internal Orders.XLS, BW-Internal Orders.XLS & FDW-Internla Orders.xlsx) into .xlsm file using macro's. The files should be imported from a path (e.g D:\Fakepath\) with a Button.
2.) After importing the files in .xlsm remove the blank rows. (like we have in "BW-Internal Orders.XLS", ECC-Internal Orders.XLS).
3.) After that remove header in column A ("07.08.2018 Dynamic List Display 1") which is repeating on ROW 1, ROW 3455 in BW-Internal Orders.XLS , also in ECC-Internal Orders.XLS.
4.) In ECC-Internal Orders.XLS needed only (CoCd Order Type Entered by Created on) columns when importing to .xlsm file.
5.) In BW-Internal Orders.XLS needed only (Company code Order Order type) columns when importing to .xlsm file.
6.) In FDW-Internla Orders.xlsx needed only (COMPANY_CODE IO_CODE IO_TYPE_CODE ORDER_CATEGORY_CODE SRC_SYS_ID) columns when importing to .xlsm file.
7.) For Vlookup need to use "Order" column of ECC-Internal Orders.XLS -- base file for vlookup, in BW-Internal Orders.XLS same "Order" column for vlookup , in FDW-Internla Orders.xlsx use "IO_CODE" column or vlookup.
8.) The vlookup column should be copied to new sheet called "Reconcile", the reconcile column should have only vlookup column.
Bookmarks