Macro for finding dates [Solved/Closed]

Report
Posts
38
Registration date
Monday January 2, 2012
Status
Member
Last seen
April 21, 2018
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hi guys,

Is there a macro that would give me the the cells in a column in which there are dates between 2012 and 2013. It can be easily filtered but I would like to have the results returned on a different sheet.
Any ideas please?

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
760
Start macro recorder
apply filter
copy the rows
paste to other sheet
stop recorder
macro template is ready
Thanks Rizvisa1, I have tried this but when I hit the run button with this macro, nothing gets copied but empty cells.)
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
760
You have to record the macro first or have a macro first. If you have the macro, paste the macro