command button function
 

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

command button function
 

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" wrote in message
...
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