+ Reply to Thread
Results 1 to 2 of 2

Compile data from multiple sheets

  1. #1
    Registered User
    Join Date
    02-29-2012
    Location
    Lexington, KY
    MS-Off Ver
    Excel 2010
    Posts
    1

    Exclamation Compile data from multiple sheets

    I am trying to compile data from multiple sheets (at the moment I have 10 sheets) into one sheet. Each sheet tracks calls made by one salesmen, and all of my salesmen have a different number of clients, so while each sheet has the same number of columns (client name, product, date, etc.), the number of rows (clients) varies. I have already given specific permissions for the salesmen to access their own sheet, but now I would like to figure out how to bring all the sheet data into one summary sheet automatically. I'd like to be able to sort the data at the same time, but I know that's probably not a possibility.

    Also, on another note, can anyone refresh my memory on how to call a sheet name to a cell? I think I've done it before, but I can't find where/how I did it.

    Thanks!
    Last edited by procon4077; 02-29-2012 at 01:22 PM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: Compile data from multiple sheets

    To bring all data to your summary sheet you can use this add-in by Ron de Bruin.
    The code is also available and can be tweaked if necessary

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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