+ Reply to Thread
Results 1 to 2 of 2

Combine Data from Multiple Sheets to Single Sheet

  1. #1
    Registered User
    Join Date

    Combine Data from Multiple Sheets to Single Sheet

    I am sure that this has been asked but I have been unsuccessful in locating a solution.

    I have file with over 90 sheets (90 days of data) and need to combine all into one sheet. The data sometimes exceeds 65k so an additional filter of copying only the data with an amount greater than $1,000.00 would be required. Please see the attached.

    Any help would be greatly appreciated as copy/paste is a real inconvenience.


    FYI - Sorry this was posted in the wrong forum. Can one of the moderators please move?
    Attached Files Attached Files
    Last edited by mpquin; 03-13-2009 at 09:07 AM.

  2. #2
    Forum Expert
    Join Date
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007

    Re: Combine Data from Multiple Sheets to Single Sheet


    See the attached workbook "Data Filter AutoFilter copy values greater than 1000 from all sheets - mpquin - SDG.xls", and run the "CopyData" macro.

    Have a great day,
    Have a great day,

    Windows 10, Excel 2007, on a PC.

    If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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