Previous Topic Next Topic

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 4478 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?
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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
Dg83
Sep 26, 2012 at 01:52 PM
Thanks Rizvisa1, I have tried this but when I hit the run button with this macro, nothing gets copied but empty cells.)
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Similar discussions

encryption message several time in chat
measking -
HelpiOS -

1 response
IF statements with dates and criteria
jimbabama -
Mazzaropi -

3 responses
blank white page for website
yadaves -
ac3mark -

1 response
using web browser page loads but screen blank
inchoate -
leo -

16 responses
using nested if to blank out adjacent cells
WILLYB -
mubashir aziz -

3 responses