Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Extract data date wis

0

Required VBA code for below condition..

I have data in sheet 1 and in last column ("Column D") i have date in every cell, now my requirment is to copy the data date wise and paste in new sheet.

for example " all the rows which have 02-Apr-19 in column "D" copy and paste in new sheet and the rows which have 03-Apr-19 paste in another sheet and 5-Apr in next sheet.

file attached for reference

Thanks for help

excel
MS Office Version: 16
posted by: Mannu (rep: 2) on Fri May 24, 2019 at 4:24 am
Answer
Discuss

Discussion

Hello Mannu, This site doesn't offer a free code writing service. You will find help here for the code trying to write code yourself. Please post the code you already wrote and rephrase your question to point to the difficulty you encountered.
Variatus (rep: 4889) May 24, '19 at 5:57 am
Hi Mannu.
As per the last time you asked this question you will need to loop through your data and make decisions as to the actions to be performed.
I would suggest you record some of you actions - select date - Copy Row - Add a sheet - past row. Then check out this site to see if there is training on looping through data and how to use "IF". Once you have done this and require additional guidance we will be pleased to help 
k1w1sm (rep: 197) May 26, '19 at 7:16 pm
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login