In Excel: Possible to Have User Select Date Range and Copy Range to New Sheet

[shelby55]

Hello

I am using Excel 2007. I would like to be able to create a macro where the user enters a start and end date and that range is used as the filter to extract data from one worksheet to another.

Is this possible? Thanks.

 

[PHV]

What have you tried so far and where in your code are you stuck ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[combo]

You can use RefEdit control in the userform. It has to be modal.
Another option is to use Application.InputBox with Type=8.
Both enable you to select sheets and ranges.


combo

 

[SkipVought]

Turn on your macro recorder and record performong the filter, select & copy.

The copy rang is best performed on a Structured Table using ST References.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}