View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SDH SDH is offline
external usenet poster
 
Posts: 19
Default 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