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
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.
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks