+ Reply to Thread
Results 1 to 6 of 6

Need help combining table data from a range of worksheets to a separate worksheet

  1. #1
    Registered User
    Join Date
    02-23-2014
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    5

    Need help combining table data from a range of worksheets to a separate worksheet

    Hello and thanks for taking the time to read my post/plea for assistance.

    I an currently using Office 2013. I am relatively competent with excel formulas but know absolutely NOTHING of VBA coding or Macros. I have a workbook that has roughly 30 spreadsheets in it. 25 of these sheets contain tables that are identical in formatting and number of columns/column headers. The number of rows, however, differs between each table/sheet. The goal is to create a new table, on a separate sheet, which would summarize the information of all the tables. Some columns may have duplicate values, and others may not. I do not want to copy the unfilled rows from each table into the new one, only those which contain data. As I mentioned, the data to be combined is within "only" 25 of the sheets of the 30 sheet workbook. I would prefer for the summarization to happen as items are entered, verses having to press a button, or cntrl+Shift+ something key combination. I'm not entirely sure this is even possible, but thought I'd take the chance and ask. The file is slightly larger than the upload limit will allow so I deleted a good majority of the sheets, hopefully what remains will be enough to provide a better idea.

    I may well have forgotten to provide some key points of information needed so please let me know if there are crucial elements I neglected.

    Thanks
    Robert
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: Need help combining table data from a range of worksheets to a separate worksheet

    Hi, welcome to the forum

    Maybe Im missing something, but where is your data, and where do you want it to go? Can you provide a few sample answers to make it easier to see what you want?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    02-23-2014
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: Need help combining table data from a range of worksheets to a separate worksheet

    Not missing anything, but perhaps I should have input fictitious data. This workbook is to track new hired employees during a job fair. They will be assigned to specific orientation dates, I need each "date sheet" <Original> to summarize in the "combined (all dates)" sheet. The sheet names, currently original, original (2) . . .up to original (25) <which have been deleted so I may upload the workbook> will be renamed based on the date and time of orientation classes.

    I have filled in some basic info, but it will be the same type of data in each column in corresponding date sheets.
    Attached Files Attached Files

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: Need help combining table data from a range of worksheets to a separate worksheet

    I am unable to open that file, it says it is corrupt Can you try again?

  5. #5
    Registered User
    Join Date
    02-23-2014
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: Need help combining table data from a range of worksheets to a separate worksheet

    Hopefully this works - thanks for your time!!
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    02-23-2014
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: Need help combining table data from a range of worksheets to a separate worksheet

    It may be helpful to note than on any given date (sheets named original) there will be no more than 150 rows of data. There may be some with none!

+ 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. Replies: 2
    Last Post: 10-14-2012, 10:00 AM
  2. Combining Data from Separate Worksheets [Please Help]
    By rockproper in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-11-2012, 12:22 PM
  3. Replies: 1
    Last Post: 05-09-2012, 07:33 AM
  4. Finding dupicate data in two separate worksheets and combining rows
    By step10solutions in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-08-2008, 01:18 PM
  5. Replies: 1
    Last Post: 08-10-2006, 02:53 PM

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