+ Reply to Thread
Results 1 to 2 of 2

Pull two columns out of all Excels in a folder

  1. #1
    Registered User
    Join Date
    10-01-2019
    Location
    DC / DE / UK
    MS-Off Ver
    Excel for Office 365 64-bit
    Posts
    1

    Post Pull two columns out of all Excels in a folder

    Hi everyone,

    First post here. Excited to read and learn some new things I can put to use. Have been searching for a few weeks and tried a few macros but can't seem to string it all together for a recent analysis I'm trying to accomplish. Any help or ideas are greatly appreciated!

    Case
    - Within a folder new Excels are added daily which contain new information including two columns which I'm specifically interested in which are called "Lif #" and "Tin #"
    - I'm looking for a macro or any method that would search all of these Excels and look for those two specific columns that could be in each Excel workbook which could also have multiple worksheets
    - Output would be a new worksheet that lists the results of all the searches and all rows with the columns "Lif #" and "Tin #"
    - I could then use the results to do a concatenation of the "Lif #" and "TIN #" to create a unique key, then use this key as a lookup against a master list to see if the results are found or missing against the master list (unless this could also be automated somehow and missing lines highlighted).
    - The format of the Excels can change, depending on the condition. One Excel will have these two values in specific columns but another Excel could have them in two different columns

    I've found a few macros that allow searching just for the one string I can do, but I haven't been able to tie them together to get a complete anlaysis with results returned like the above.

    Thanks again!
    - J

  2. #2
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,249

    Re: Pull two columns out of all Excels in a folder

    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

+ 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] want to append all data of different excels of a folder into one excel sheet
    By ROHAN999 in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 09-04-2018, 02:35 PM
  2. [SOLVED] Looking for Macro to pull folder name and folder size of a specific location.
    By TheDirtyDrunk in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-07-2016, 09:19 AM
  3. How to get data from many excels in one folder
    By asd1234asd in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-28-2016, 04:08 AM
  4. Pull tab from desktop folder
    By excelnoob927 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-26-2014, 12:37 PM
  5. VBA code to password protect all excels files in a folder
    By jaincool123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-03-2014, 07:19 AM
  6. Replies: 0
    Last Post: 12-07-2010, 12:41 PM
  7. Pull Data from Folder of Workbooks
    By mv835 in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 11-13-2008, 10:33 AM

Tags for this Thread

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