Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
year end sales report with old and new customers
I have to do a sales projection report showing what my customers did for the
year and what new customers I will be bringing on with $ amount of new business. I am looking for a templete that will show me this. I purchased Quick Books, but that does not seem to be what I am looking for. Please help I only have the weekend to do it. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
year end sales report with old and new customers
Margaret,
I am thinking you don't really need a template. I am also wondering if you don't use Excel much, so I am suggesting that you open up Excel to a blank workbook, type Customer Name at the top of one column and Amount of Purchases in the next column and Projected Purchases in the third column and then fill the in rows with your information. Company ABC - $10,546 - $15,000 Is that going to be sufficient? Do you need that e-mailed to you? Tofer "Margaret" wrote: I have to do a sales projection report showing what my customers did for the year and what new customers I will be bringing on with $ amount of new business. I am looking for a templete that will show me this. I purchased Quick Books, but that does not seem to be what I am looking for. Please help I only have the weekend to do it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combination Graph with current year and prior year sales | Charts and Charting in Excel | |||
How do I calculate year vs. year sales in a percentage? | Excel Discussion (Misc queries) | |||
Add Sales Goals to Sales Report in Pivot Table | Excel Discussion (Misc queries) | |||
How can I report all new customers that have booked training? | Excel Programming | |||
Year to Year Sales Data Sort | Excel Programming |