View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
timboy6 timboy6 is offline
external usenet poster
 
Posts: 3
Default Customized Report Summary?

Hello,

How can I create a button on a worksheet?

When pressed, it will look at a range (ex. a1-a6), which are predefined
names such as lodging, marketing, sales, etc. and sum them up?
I.E. there are 3 "lodging" entries and 3 "sales" entry and tell me that by
displaying the summary on h1-h6? And b1 - b6 is the amount in $$$ used for
the entry?

Example for summary:
So there are 3 lodging for a total of $4
and there are 3 Sales for $15

Example:
A B
(I would like a button here)
1 Lodging $2
2 Lodging $1
(Display my summary here)
3 Lodging $1
4 Sales $5
5 Sales $5
6 Sales $8