+ Reply to Thread
Results 1 to 4 of 4

extract data between two dates from multiple sheets and paste all in one sheet

  1. #1
    Registered User
    Join Date
    11-12-2013
    Location
    lahore pakistan
    MS-Off Ver
    Excel 2007
    Posts
    44

    Post extract data between two dates from multiple sheets and paste all in one sheet

    Hi,


    i have a workbook containing 12 sheets. All sheets are of same format. Currently i am trying to extract data from all sheets between two dates and paste all data on one sheet.

    If i could get some VBA code to do the job?

    Thanking you in anticipation.

    Rahat

  2. #2
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: extract data between two dates from multiple sheets and paste all in one sheet

    Hi,

    I could not help you with Vba.

    Maybe if you upload a little sample file, some friend of the Forum could try to help.
    -----------------------------------------------------

    At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.

    Please, mark your thread [SOLVED] if you received your answer.

  3. #3
    Registered User
    Join Date
    11-12-2013
    Location
    lahore pakistan
    MS-Off Ver
    Excel 2007
    Posts
    44

    Re: extract data between two dates from multiple sheets and paste all in one sheet

    Hi Canapone,

    Thank you for your response.

    I have made it easy. Now i have to extract data between two dates with specific columns other than date column from one sheet and paste extracted data in another sheet.

    please help me out.

    regards

  4. #4
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: extract data between two dates from multiple sheets and paste all in one sheet

    Hi,

    supposed your dates are in sheet1 A2:A1000

    If in Sheet2 in A1 start date, in B1 - end date, a possible approach could be in copy C1 ( to be confirmed with control+shift+enter ) and down and across

    Please Login or Register  to view this content.

    I cannot help you with VBA.


    Regards

+ 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. [SOLVED] Extract multiple sheets data into one sheet
    By jun22 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-20-2014, 09:58 AM
  2. Macro to Extract Data from Multiple Sheets into One Sheet
    By BillW93 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-05-2013, 10:55 AM
  3. [SOLVED] How to code a macro to extract data from multiple sheets into one sheet?
    By likeabottle in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-21-2013, 04:51 PM
  4. Need cut and paste data from multiple sheets to one master sheet
    By cokillerliu in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-06-2013, 06:41 PM
  5. Copy data in multiple sheets and paste into one sheet.
    By Slomaro2000 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-05-2008, 05:27 AM

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