Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Looking for a creative sol'n to sales region map
Hi all - I manage a major account with many locations. I created a SS to
list each location and the sales person handling it. Some locations have lots of sales activities others may have nothing. I linked the SS to another SS that maintains a list of the contacts for each location. That is, click on a location and another sheet comes up with the contacts for that location listed. I did the same with notes using a word document. So with this growing database I want to simply know what is happing with the entire major account at any one time. I will be asked by my boss to give feeback on this and I want to act like I am on top of things i.e. Johnny on the spot. Other than using color codes or sorting showing hot vs. cold activities what can I do to summerize the hot activities at a glance? Also, is there a way to import say a map of the US and create links on the map to each location of the major company? Is Excel the right choice here? Any ideas or tips would be greatly appriciated - Sprite8 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Looking for a creative sol'n to sales region map
Any ideas? Anyone?
"Sprite8" wrote in message ... Hi all - I manage a major account with many locations. I created a SS to list each location and the sales person handling it. Some locations have lots of sales activities others may have nothing. I linked the SS to another SS that maintains a list of the contacts for each location. That is, click on a location and another sheet comes up with the contacts for that location listed. I did the same with notes using a word document. So with this growing database I want to simply know what is happing with the entire major account at any one time. I will be asked by my boss to give feeback on this and I want to act like I am on top of things i.e. Johnny on the spot. Other than using color codes or sorting showing hot vs. cold activities what can I do to summerize the hot activities at a glance? Also, is there a way to import say a map of the US and create links on the map to each location of the major company? Is Excel the right choice here? Any ideas or tips would be greatly appriciated - Sprite8 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
??SUMPRODUCT? other solution? | Excel Worksheet Functions | |||
Calculate Total Sales from a Database | Excel Worksheet Functions | |||
formula to calculate sales tax from total sales | Excel Worksheet Functions | |||
Trying to create a Sales Projection/Forecast/Estimate | Excel Discussion (Misc queries) |