Finding and Selecting Specific Ranges

[halper]

This is my first post, so please bare with me if I am not as detailed
as required.

Here is a quick layout of my sheet.

Date Account Amount Description
5/1/2005 12345 10 Expense
11111 20 Expense
5/2/2005 136589 200 Cash
135965 1560 Cash

I am trying to write code that will search the date column and then
select all the data from 5/1/2005 and then use it somewhere else and
then go back and select the 5/2/2005 data and so on.

Thanks for all the help.

 

[Bob Phillips]

Bit more specific. Use it somewhere else means what exactly?

 

[halper]

What I want to do is take the range and then copy it to another sheet
and then re-format it for an auto upload into a database. So once the
range has been defined, I am going to copy the range to the other sheet
and then format it to desired settings.

Hope this is more specific.

 

[Bob Phillips]

Can I suggest that you start by recording a macro.

Go through the steps of using Data>Filter>Autofilter, pick the required
date, copy the visible rows and paste them, and do your formatting, all
whilst recording.

You should have a good start code to work with then.