Extract data date wis


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



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: 3838) 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