Data searching based on cell contents using VBa
 

Hi,
I'm trying to set range names and criteria for searching an excel data base
based on start and finish dates.
I want to be able to enter a start and a finish date in a cell, and then
have the rest of the information sorted based on the start and finish date I
select.
I'm trying to setup some automatic graphing functions for an Admin Assistant
--
Thankyou for your time

Data searching based on cell contents using VBa
 

Sorting does not seem the problem here. Pick the column with the dates and
sort it asending. The hard part will be finding the first occurance of the
start date and the last occurance of the ending date, then you need rows
above the start date with headers and an empty row below the ending date.
Assumng all columns will be grahed, then you will have to select the region
and graph it. Seems we would we data to start with. Good luck.

"Craig Easton" wrote:

Hi,
I'm trying to set range names and criteria for searching an excel data base
based on start and finish dates.
I want to be able to enter a start and a finish date in a cell, and then
have the rest of the information sorted based on the start and finish date I
select.
I'm trying to setup some automatic graphing functions for an Admin Assistant
--
Thankyou for your time