+ Reply to Thread
Results 1 to 2 of 2

Import data from .XLS, xlsx file into .xlsm file and do vlookup

  1. #1
    Registered User
    Join Date
    08-14-2018
    Location
    India
    MS-Off Ver
    2016
    Posts
    46

    Import data from .XLS, xlsx file into .xlsm file and do vlookup

    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.
    Attached Files Attached Files
    Last edited by pacificepoc; 08-20-2018 at 01:41 AM. Reason: adding files

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Import data from .XLS, xlsx file into .xlsm file and do vlookup

    Maybe do some research on Power Query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Import .xls file in .xlsm file using macro and vlookup the sheets in new sheets
    By pacificepoc in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-16-2018, 04:06 AM
  2. Replies: 1
    Last Post: 12-01-2016, 10:57 AM
  3. Saving .xlsm file to .xlsx
    By BrianAll in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-09-2015, 09:23 PM
  4. Replies: 3
    Last Post: 05-21-2013, 08:22 AM
  5. Saving xlsm file as xlsx while running macro
    By happygilmore in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-29-2012, 02:32 PM
  6. [SOLVED] Save xlsm file as xlsx file
    By ccpsc in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-06-2012, 01:12 AM
  7. Saving .xlsx in a network folder through a .xlsm file
    By jambai in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-18-2011, 04:09 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1