Sorting out weekly Sales
Posted by Bill on January 10, 2002 1:26 PM
I would like to know if there is a way that I could pull out the sales of each salesmen by setting a from ---> to date. Each person enters all thier quotes into a seperate sheet in the workbook. Once they make the sale there is a macro that they run to send it to another sheet where all the salesmen data is sorted and finally goes to a 3rd sheet where all of the relvant data is shown. Is there any way that I can find out their sales by setting a from -> to date and it will tell me their sales for that period.
I could really use the help, and if you have any question I'll trying and clear them up.