| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Customized Report Summary?
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
|
|||
|
|||
|
Customized Report Summary?
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
|
|||
|
|||
|
Customized Report Summary?
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
|
|||
|
|||
|
Customized Report Summary?
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 | |
|
|
Similar Threads
|
||||
| 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 | |||
Linear Mode
