Results 1 to 28 of 28

Copy Data from Several sheets to one based on Date range when date is stored in col A

Threaded View

  1. #1
    Registered User
    Join Date
    06-10-2011
    Location
    United States, New York
    MS-Off Ver
    Excel 2003
    Posts
    14

    Copy Data from Several sheets to one based on Date range when date is stored in col A

    Please assist, I have a VBA Marco I'm trying to write that would copy data from one or several worksheets onto a separate sheet within the same workbook based on date information stored in column A of these sheet(s).

    The workbook contains several worksheets with the first column of these containing the date for each record. I wish to have excel return all rows that contain data that falls within the date range selected and place the information on the "Statement Template" sheet starting in row A21.
    Perhaps a popup box to enter the date parameters with a dropdown selection for each sheet to choose or an "ALL"option to retrieve information from all sheets.
    I have attached a copy of the spreadsheet with three of the sheets containing data and the Statement Template sheet.
    Attached Files Attached Files
    Last edited by NBVC; 08-18-2011 at 05:02 PM. Reason: Marked Solved per OP request

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