SOURCE: Application of Pivot table & Sub total with Examples
Suppose you have a Database regarding sales of this Month inthe Column and Row Fromat with column Heading SalesPerson, Company, Product and Amount. where salesperson sales to different company different Products more than once. In this type of Database Salesperson, Company and Products appears more than once. Now you can use PivotTable to view and analyze your data in different Formats like Salesman wise COmpany wise and Productwise with different formatting REports with a facility of Preparing Charts too.
SOURCE: Closing Worksheet on executing Hyperlink command
You could do this by creating a close button with the worksheet- Do this via insertin ga prompt in Macro.
Start off by doing one of the following: Select the range of cells that you want to make into a table within your worksheet then proceed to Step 2 OR Start immediately with Step 2.
Click on the "Insert" tab at the top of the document.
Find the "Tables" group, then click on "Table." The "Create Table" dialog box will appear.
Type in a range for your table if you did not select a range in Step 1. If you did already select a range then that range will automatically appear in the dialog box.
Check the "My Table Has Headers" box if the data set you selected already contains the headers you want to use. If you don't check this box, the table will display default header names, which you can then go in and change.
Hit the "OK" button at the bottom of the Create Table dialog box to create your table.
Keyboard shortcut You can also press CTRL+C.
Keyboard shortcut You can also press CTRL+V.
Notes
Prepare table having coloumns Client, Premium Amount , Month.
Now take Pivot table of the above table. Take Field 'Month' in Page field and Client in 'Row' field and sum of amount in 'Data field'.
If you refresh the data and select the required month you will get the desired information.
34 views
Usually answered in minutes!
×