| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum Workbook on Worksheet
I would like to create a summary worksheet at the end of my workbook that
would add all the Acres (see below) of each Lessor on all worksheets. Each sheet of the workbook contains information like below. Each Lessor is on one or more of the app. 100 sheets, as are Lessees. Lessor Acreage Interest Acres Royalty Lessee Joe 100 0.25 25 0.125 Humble Sam 200 0.75 150 0.125 Gulf Edd 80 1.00 80 0.125 Gulf Mac 640 0.50 320 0.125 Humble I would like to make a summary sheet that be similar to the other worksheets, but with totals of all worksheets of the workbook by each Lessor and/or by each Lessee. Thanks Jerry |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Data from Workbook into specific Worksheet in other Workbook? | Excel Discussion (Misc queries) | |||
| Link worksheet totals to a summary worksheet in the same workbook | Excel Worksheet Functions | |||
| Copying A Worksheet From Each Open Workbook to an new Workbook | Excel Worksheet Functions | |||
| How can I link cell colours from worksheet to worksheet/workbook? | Excel Worksheet Functions | |||
| copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions | |||
Threaded Mode
