Macro for finding dates

Solved/Closed
DG83 Posts 38 Registration date Monday January 2, 2012 Status Member Last seen April 21, 2018 - Sep 25, 2012 at 10:39 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Sep 26, 2012 at 05:47 PM
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

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Sep 25, 2012 at 06:06 PM
Start macro recorder
apply filter
copy the rows
paste to other sheet
stop recorder
macro template is ready
0
Thanks Rizvisa1, I have tried this but when I hit the run button with this macro, nothing gets copied but empty cells.)
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Sep 26, 2012 at 05:47 PM
You have to record the macro first or have a macro first. If you have the macro, paste the macro
0