+ Reply to Thread
Results 1 to 3 of 3

Collating Information from Multiple Spreadsheets

  1. #1
    Registered User
    Join Date
    05-02-2021
    Location
    Banham
    MS-Off Ver
    Office 365
    Posts
    2

    Collating Information from Multiple Spreadsheets

    Have a spreadsheet which contains numerous strand of information, mainly concerned with data pertaining to customer visits.

    Would like extract the employee's name who will be taking the visit and report this the the customer.

    Problem incurred. Some customers have multiple visits daily, data is being collated from daily spreadsheets onto a weekly format

    My skill level within excel is somewhere between "more than my colleagues - less than you", mostly self taught and do not always understand the terminology used by experts.

    Believe there is is a vba code somewhere which could help, hoping someone will save me
    Last edited by ForrestA; 05-02-2021 at 06:27 PM. Reason: Adding Excel Example

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,409

    Re: Collating Information from Multiple Spreadsheets

    Hi Forrest and welcome to the forum,

    Power Query might have the tool you are looking for. If all those files are in the same folder, you can import only the parts of each file you want. See:
    https://www.myonlinetraininghub.com/...%20items...%20
    for a start. BTW - if this answer doesn't give you a lead then keep asking. Also, attaching a workbook will get you much more help here.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    05-02-2021
    Location
    Banham
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Collating Information from Multiple Spreadsheets

    Thank you for this, interesting although not quite what I need for this one. I did add a spreadsheet to my original query which might assist you to see what I am looking at/for.

+ 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] Collating Spreadsheets
    By Farley945 in forum Excel General
    Replies: 14
    Last Post: 04-15-2021, 07:32 AM
  2. Replies: 1
    Last Post: 03-06-2018, 11:46 AM
  3. Grabbing multiple information from columns from multiple spreadsheets
    By MichaelHopkins in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-13-2015, 05:11 PM
  4. Find Information from Multiple Spreadsheets
    By DomSza in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-10-2015, 11:38 AM
  5. Replies: 8
    Last Post: 10-31-2014, 12:03 PM
  6. collating information
    By Back2Basics in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-04-2008, 01:46 PM
  7. Collating information in a different location
    By tom300181 in forum Excel General
    Replies: 3
    Last Post: 08-04-2005, 04:03 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