Searching cells using a date range?

C

Chris

I have a large spreadsheet (CSV) with over 3000 lines of info. Each line has
a date and time assigned to it.

I would like to be able to set up some macros that would search and copy
specific lines based on a start date and end date!

Is it possibel to create some sort of menu where i can input the start and
end dates and have the info from those specified cells copied into another
blank sheet?

I would be greatfull if someone could help point me in the right
direction.... thanks
 
M

Myrna Larson

Do you have to have a macro and menu?

Why not put the start and end date in a couple of cells on the right, say K1
and L1, and add a column to the right of your data, say H. If the existing
dates are in column D, in H2, put the formula

=IF(AND(H2>=$K$1,H2<=$L$1),"X","")

Then Autofilter on that column to display the rows with the X and copy the
displayed rows.
 
Top