Consulting

Results 1 to 2 of 2

Thread: Match columns linked to external workbook

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Regular
    Joined
    Aug 2009
    Posts
    69
    Location

    Match columns linked to external workbook

    Hi!

    I'm trying to create a VBA code that allows me to import data from another excel file based on the header.

    The master file header is fixed, but the file where I import is random and may contain more columns than necessary.
    I needed a code:
    1) to open the explorer;
    2) let me select the right file to import data;
    3) analyze the header;
    4) import the data into the master in the right places.

    the size of data file is also variable

    Please see the attachment

    Thanks in advance

    Miguel

  2. #2
    VBAX Regular
    Joined
    Aug 2009
    Posts
    69
    Location
    Anyone????

Posting Permissions

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