Ask a question Report

Macro for finding dates [Solved]

DG83 28Posts Monday January 2, 2012Registration date April 30, 2013Last seen - Latest answer on Sep 26, 2012 10:47pm BST

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?

Answer

rizvisa1 4230Posts Thursday January 28, 2010Registration date ContributorStatus May 7, 2013Last seen Sep 25, 2012 11:06pm BST

Start macro recorder
apply filter
copy the rows
paste to other sheet
stop recorder
macro template is ready

Add comment

Dg83 - Sep 26, 2012 6:52pm BST

Thanks Rizvisa1, I have tried this but when I hit the run button with this macro, nothing gets copied but empty cells.)

rizvisa1 4230Posts Thursday January 28, 2010Registration date ContributorStatus May 7, 2013Last seen - Sep 26, 2012 10:47pm BST

You have to record the macro first or have a macro first. If you have the macro, paste the macro

Reply to this topic

Ask a question

Not a member yet?

sign-up, it takes less than a minute and it's free!

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Macro for finding dates [Solved]

Not a member yet? sign-up, it takes less than a minute and it's free!

Not a member yet?

sign-up, it takes less than a minute and it's free!