Select a range of data dependant on the users input ie dates

[Rachel]

Hi,

I am working on an attrition report and want to be able to select a
range of data dependant on the users input. For example ask the user
to specify a start and end date, which would then select the rows that
are between these dates. (eg For all people who work in left between
1/3/07 and 1/4/07) This selected range would then automatically update
a graph to show attrition reports between certain dates.

Any help would be greatly apprciated

x

 

[Guest]

Hi Rachel,

VBA is your answer here. Use an inputbox to get the report start and end
dates from the user. Validate the entry with the ISDATE function and then
call excel's built in autofilter function, supplying the custom parameter
dates. Have the graph linked to the data sheet to take advantage of the fact
that when graphed data is filtered, excel automatically only graphs the
visible data.

 

[Roger Govier]

Hi

You could use Advanced Filter to extract the data to a second sheet,
where you have entered your 2 dates.
Create the graph based upon the second sheet.

For more information on Advanced Filter, take a look at Debra
Dalgleish's site
http://www.contextures.com/xladvfilter01.html#ExtractWs