I have a command button (cmdUpdate Sumary) on UserForm1. When i click the
button i need it to ask for a start and finish date. These dates need to be
used to produce a new worksheet (Summary). The sheet needs to show the sales
made (which are entered on worksheet "Clients") that fall in between the
start and finish dates entered. The Client sheet contains the dates in column
F of the work sheet and the following information in the other columns:

A Name of Group
B Address
C Contact Person
D Product
E Quantity

Take it in stages:
- Give the user an InputBox/TextBoxex/Calendar control to select/enter the 2
dates
- Add + rename a new worksheet
- Filter/Copy/Paste or use formula to get the required data into the new
sheet.

You can record a macro for the 2nd and 3rd steps.

Post back when you have a specific question/issue.
I doubt anyone is going to write all the code for you.

NickHK

"SDH" <(E-Mail Removed)> wrote in message
news:73AA8646-4E23-4737-BBF8-(E-Mail Removed)...
> I have a command button (cmdUpdate Sumary) on UserForm1. When i click the
> button i need it to ask for a start and finish date. These dates need to
be
> used to produce a new worksheet (Summary). The sheet needs to show the
sales
> made (which are entered on worksheet "Clients") that fall in between the
> start and finish dates entered. The Client sheet contains the dates in
column
> F of the work sheet and the following information in the other columns:
>
> A Name of Group
> B Address
> C Contact Person
> D Product
> E Quantity