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?

Macro for finding dates
Spell number in excel without macro - Guide
Macro excel download - Download - Spreadsheets
Automatically run a macro when opening a worksheet - Guide
Excel macro to create new sheet based on value in cells - Guide
Formula for finding position in excel - Office Software Forum

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

How to calculate positions (1st,2nd,3rd...) in Excel

How to calculate position (1st,2nd,3rd) in excel....?

Modern Warfare 2 online cant find matchs why

Calculation of positions in excel

Code for macro that conditionally inserts rows

Similar discussions

Subscribe To Our Newsletter!