Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with setting up a sales tracking workbook
I currently have a template in which daily sales are tracked. I have a
summary sheet and then a sheet per working day of the month. Each of the daily sheets are linked to our client list on the summary sheet. 1. Is there anyway I can set up the daily sheets so that if I add another client to the summary sheet, the other sheets will automatically update and vice versa if I delete a client? 2. Each month I save the sales for the month but would like to have visibility of what the salespeople have sold over the year - a running monthly total from April -March. At the moment I have a very simple link to the previous months workbook or some of our girls even just type in the figure. Is there any way to automate this? Any suggestions would be great. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sales tracking report | Excel Worksheet Functions | |||
Tracking daily sales templates? | Excel Discussion (Misc queries) | |||
tracking daily and monthy sales | Excel Discussion (Misc queries) | |||
exceL NOOB needs help w/sales tracking | Excel Discussion (Misc queries) | |||
tracking sales to targets in a chart | Charts and Charting in Excel |