Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
anyone have a basic sales tracker
I am looking for a basic sales tracker for work that can keep track of my
monthly sales. I jsut need to be able to list the company name/quote #/Order#/ Total Rev anue/Total Gross Margin. the Total Rev and GM need to have a formula to be added up. I also need to have a space to put in my monthly quota and have it tied into the Gross Margin since thats what I am paid on at work. So when I put in the GM i made on the sale it subtracts from my quota and tells me how much I have left to sell. I have alot of this done but it doesnt look as good as I want it too. Also, I cant remember any % formulas but I would also like this tied into the Commossion space so that it Tells me where I currently am % wise for the month. If anyone has any suggestions or somehting simlar let me know. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
anyone have a basic sales tracker
Hi there,
I have a tool on my website that you can probably use to get most of the info you want and you can certainly alter it to suit. You might want to check it out.. Here's the URL... E:\!!Websites\http_excelwell-excel-templates.110mb.com\active\site \excel_templates_macros_and_spreadsheets\macros\da tabase_mining.htm ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ Kim Hartnet www.excelwell-excel-templates.110mb.com "The best place on the net for free & inexpensive Excel templates, macros and spreadsheets" ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating sales commission that changes based on a sales volume | Excel Worksheet Functions | |||
Sales Invoicing linked to Sales ledger(Accounts Receivable) | Excel Discussion (Misc queries) | |||
sales tracker for a public house | Excel Discussion (Misc queries) | |||
I'm looking for a tiered sales commision tracker | Excel Discussion (Misc queries) |