| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to select rows based on dates
I have a spreadsheet with columns of data and dates. I want to be able to
select rows based on a start date and an end date. example data 13/9/09 Sun 21/9/09 Mon I2 Longman 14/9/09 Mon 22/9/09 Tue 19 Andrews 15/9/09 Tue 21/9/09 Mon 12 Best 17/9/09 Thu 23/9/09 Wed 15 James 17/9/09 Thu 5/10/09 Mon 22 Wilson 17/9/09 Thu 22/9/09 Tue 7 Hole 18/9/09 Fri 18/9/09 Fri 6 Ratcliffe 18/9/09 Fri 3/10/09 Sat 11 Jones Can I get a macro to select from the first row containing 13/8/09 in column A to the last row containing 18/9/09 in column A? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need Macro- Insert rows based on dates and copy info from that row | Excel Discussion (Misc queries) | |||
| Macro to show/hide rows based on a range of dates | Excel Programming | |||
| Select rows based on criteria | Excel Worksheet Functions | |||
| Macro to select rows based on a value in a column | Excel Programming | |||
| How to Select Range based on dates in cells | Excel Programming | |||
Threaded Mode
