+ Reply to Thread
Results 1 to 3 of 3

Combining Data from multiple (100+) spreadsheet into 1 master spreadsheet

  1. #1
    Registered User
    Join Date
    08-10-2011
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    2

    Unhappy Combining Data from multiple (100+) spreadsheet into 1 master spreadsheet

    Dear all,

    I am unsure how to search for this due to the nature of my problem but I was wondering whether you guys could help.

    I need to collate data from about 100 spreadsheets, each with a number of columns (say 10-12) and about 10-50 rows in each, and then place this data in a Master spreadsheet.

    For example, if I had a table of Names, eye colour, height, occupation of 100 different companies, I need to make 1 spreadsheet with the company name and then all the different parameters.

    The reasoning for this is to allow users to find common company data to use as a comparison for new business, without having to search through each and every spreadsheet on the system. Copying and pasting will take far too long.

    Also, to add some slight confusion, the headings on each table may be different. i.e. "Eye colour" may be called "colour of eyes" on another table.

    Any assistance will be much appreciated. I am NOT an excel wizard but am very good at following instructions.

    Await your comments suggestions.
    Jamie

  2. #2
    Registered User
    Join Date
    08-10-2011
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Combining Data from multiple (100+) spreadsheet into 1 master spreadsheet

    Apologies, Mods please can you move this to the relevant section.

  3. #3
    Registered User
    Join Date
    01-08-2010
    Location
    Upstate NY
    MS-Off Ver
    Excel 2000
    Posts
    1

    Re: Combining Data from multiple (100+) spreadsheet into 1 master spreadsheet

    Is this being answered somewhere? I have a similar situation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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