Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I would suggest to have the summary displayed in another column; which will
auto change upon new entries to Col A and ColB. In Col C you enter the unique entries..and D1 apply formula =SUMIF(A:A,C1,B:B) Copy down the formula to D2, D3....which will give you the total for each head. Now try adding/editing/deleting entries to Col A/B Col A Col B Col C Col D Lodging $2 Lodging 4 Lodging $1 Sales 18 Lodging $1 Marketing 0 Sales $5 Sales $5 Sales $8 If this post helps click Yes --------------- Jacob Skaria "timboy6" wrote: 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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thank you Jacob!
It helped me, but do you know how I can add a button or something similar so that when pressed it will display the summary? Right now I have the summary working, but it is always displaying. It would be nice if it only shows up when you tell it to, and is there a way also to make the file menus to disappear when a user opens this workbook? Thanks! "Jacob Skaria" wrote: I would suggest to have the summary displayed in another column; which will auto change upon new entries to Col A and ColB. In Col C you enter the unique entries..and D1 apply formula =SUMIF(A:A,C1,B:B) Copy down the formula to D2, D3....which will give you the total for each head. Now try adding/editing/deleting entries to Col A/B Col A Col B Col C Col D Lodging $2 Lodging 4 Lodging $1 Sales 18 Lodging $1 Marketing 0 Sales $5 Sales $5 Sales $8 If this post helps click Yes --------------- Jacob Skaria "timboy6" wrote: 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 |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Try PIVOT table..
http://www.youtube.com/watch?v=7zHLnUCtfUk If this post helps click Yes --------------- Jacob Skaria "timboy6" wrote: Thank you Jacob! It helped me, but do you know how I can add a button or something similar so that when pressed it will display the summary? Right now I have the summary working, but it is always displaying. It would be nice if it only shows up when you tell it to, and is there a way also to make the file menus to disappear when a user opens this workbook? Thanks! "Jacob Skaria" wrote: I would suggest to have the summary displayed in another column; which will auto change upon new entries to Col A and ColB. In Col C you enter the unique entries..and D1 apply formula =SUMIF(A:A,C1,B:B) Copy down the formula to D2, D3....which will give you the total for each head. Now try adding/editing/deleting entries to Col A/B Col A Col B Col C Col D Lodging $2 Lodging 4 Lodging $1 Sales 18 Lodging $1 Marketing 0 Sales $5 Sales $5 Sales $8 If this post helps click Yes --------------- Jacob Skaria "timboy6" wrote: 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 |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I will give that a shot, thank you once again Jacob. :)
Tim "Jacob Skaria" wrote: Try PIVOT table.. http://www.youtube.com/watch?v=7zHLnUCtfUk If this post helps click Yes --------------- Jacob Skaria "timboy6" wrote: Thank you Jacob! It helped me, but do you know how I can add a button or something similar so that when pressed it will display the summary? Right now I have the summary working, but it is always displaying. It would be nice if it only shows up when you tell it to, and is there a way also to make the file menus to disappear when a user opens this workbook? Thanks! "Jacob Skaria" wrote: I would suggest to have the summary displayed in another column; which will auto change upon new entries to Col A and ColB. In Col C you enter the unique entries..and D1 apply formula =SUMIF(A:A,C1,B:B) Copy down the formula to D2, D3....which will give you the total for each head. Now try adding/editing/deleting entries to Col A/B Col A Col B Col C Col D Lodging $2 Lodging 4 Lodging $1 Sales 18 Lodging $1 Marketing 0 Sales $5 Sales $5 Sales $8 If this post helps click Yes --------------- Jacob Skaria "timboy6" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
dynamic summary report | Excel Worksheet Functions | |||
automated employee tenure summary using Customized Charts with VBA | Charts and Charting in Excel | |||
summary report with duplicates | Excel Worksheet Functions | |||
Spreadsheet Summary Report | Excel Worksheet Functions | |||
How to create summary of expense report? | Excel Worksheet Functions |