LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 9th 08, 10:14 PM posted to microsoft.public.excel.misc
Sal Sal is offline
external usenet poster
First recorded activity by ExcelBanter: Jul 2006
Posts: 84
Default 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.


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Sales tracking report PSikes Excel Worksheet Functions 5 November 12th 09 09:34 AM
Tracking daily sales templates? jrm Excel Discussion (Misc queries) 0 August 23rd 06 10:58 PM
tracking daily and monthy sales RMA Excel Discussion (Misc queries) 1 March 6th 06 02:41 PM
exceL NOOB needs help w/sales tracking DIXIEDH Excel Discussion (Misc queries) 1 June 23rd 05 06:00 AM
tracking sales to targets in a chart Brad Charts and Charting in Excel 2 December 30th 04 04:12 PM

All times are GMT +1. The time now is 08:31 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017