Not sure if it's possible but....
I have a worksheet, attached. that has the sum of monthly sales. What I'd like is to have an option that I can click on the month's sales and then to the side or somewhere have the details of each sales person appear. Is this possible??
See my attached example.
Last edited by VBA Noob; 08-07-2008 at 04:34 PM.
This certainly would be possible. But where are the details of sales stored?
Your sample workbook does not seem to contain them.
Originally Posted by Kuskush
Your correct, I haven't inputed it yet, as I wasn't sure if I should do it in a certain way or something. But i could just imput them into a spreadsheet I guess with the month, then each sales persons name and their sales.
Last edited by djws; 08-07-2008 at 06:30 PM.
Anyone Able to help me out with this??
Sorry If I haven't been very clear, please see the sample2 i've attached, it's the actual worksheet.
As you'll see, there is a monthly $ field. This is the total $ of all sales ppl in the month. What I'd like to do is:
most importantly have the monthly monthly sales tab automatically totaled into the monthly sales $ colum in the report. Plus if possible automatically pull the date???
Secondly i'd like it to automatically count the billing persons (how many sales ppl billed that month) and then how many are above 7000 (bonus)
Is this possible or am I just asking something too complicated?
(it would be cool if while holding your mouse over the monthly $ it displayed the individual sales)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks