After applying filter for date, the date data is not getting filter, for advancefilter as well

[Arif_Tamboli]

Range("g1").select
do while activecell<>empty
Range("d9").autoflter ,activecell
Activecell.offset(1,0).select
loop

here range("g1) contain date from first to end and I need to activate the filter as per date and copy the data, however after run filter code filter is on but not showing filtered date.

 

[My Aswer Is This]

Please explain in words what your wanting to do.

Your showing us a script that does not do what you want.
And you said copy data but did not say copy date where.

 

[Arif_Tamboli]

Please explain in words what your wanting to do.

Your showing us a script that does not do what you want.
And you said copy data but did not say copy date where.

Hi,
Thank you for reply,
i will keep that in mind
i have dump file wherein data for month is saved datewise,
i need to pick up that data datewise on daily basis and copy it in other file.
problem: while running coad filter is getting on but data doesnt show up in below filter/header
like in excel when we filter and select a date, data for that date only whows in below header row.
here i am not getting that.