Filter 2 Dates and copy all visible data

[mohan.r1980]

Hi Sir,

In Date column i want to copy only that data which is select by user fromTo range of date
E.g. "From 01-Mar-2019 to 13-Mar-2019"
after filtered dates i want copy all the visible data and paste sheet2

I also try below code but result showing totaly blank

Please Login or Register  to view this content.

Please find the attached file

Please suggest me

[vcoolio]

Hello Mohan,

You're getting a blank result because the dates in your sample are formatted as text. You'll need to change them to Excel dates. You can do this by using the Text to Columns feature in the ribbon:-

- High-light the entire Column A.
- In the ribbon, go to the Data tab and select Text to Columns.
- In the dialogue box that appears, click on Next twice to go to the third page.
- Click on Date then click on Finish.

The format is now changed to Excel dates.
You should now be able to filter them using your code.

I hope that this helps.

Cheerio,
vcoolio.

[mohan.r1980]

thanks for reply
i do it and run the code but got blank result.

when i record the macro then it works fine

Please Login or Register  to view this content.

and when i keep my variables then it shows me blank result

Please Login or Register  to view this content.

pls suggest

[vcoolio]

Hello Mohan,

I've attached your sample workbook with the following code implemented:-

Please Login or Register  to view this content.

I've changed the date formatting as described in post #2. You'll see that it all works as it should.
You may have to change the ranges etc. to suit your actual workbook.

I hope that this helps.

Cheerio,
vcoolio.

[mohan.r1980]

Hi vcoolio,
thanks for reply with solution and also sorry for late reply.
your solution working fine

pririor i have manage the code and it also works fine

Please Login or Register  to view this content.

[vcoolio]

You're welcome Mohan.
I'm glad to have been able to assist in some way.

Cheerio,
vcoolio.