Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Command Button Function | Excel Programming | |||
command button to do F9 function | Excel Programming | |||
Command button to run calculation function | Excel Programming | |||
using command button instead of edit function | Excel Programming | |||
Command Button Function - Macro | Excel Programming |