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.