Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automate with a click if possible
I have a workbook that contains 5 worksheets, 4 of them is where the
inforamtion is stored for the 5th sheet which gives totals for ytd info and monthly info... this means alot of entry of numbers. Is there anyway to automate the totals from the other worksheets to the totals page with a click of a button, so I can have month to date and yearly totals with a click of a button? I know I still have to update the 4 worksheets with data but it would be nice if it would at least give me the report I need for my different division managers. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automate with a click if possible
One possibility ..
Try this sample from my archives*: http://savefile.com/files/414328 Interactive Summary.xls (nicely rendered, full details, easy to understand and adapt, as usual <g) *archives link in sign-off below -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- wrote in message oups.com... I have a workbook that contains 5 worksheets, 4 of them is where the inforamtion is stored for the 5th sheet which gives totals for ytd info and monthly info... this means alot of entry of numbers. Is there anyway to automate the totals from the other worksheets to the totals page with a click of a button, so I can have month to date and yearly totals with a click of a button? I know I still have to update the 4 worksheets with data but it would be nice if it would at least give me the report I need for my different division managers. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disabling click and right-click on the Picture I inserted in an Excel document | Excel Worksheet Functions | |||
Automate without add-ins | Excel Discussion (Misc queries) | |||
Click on graph bar to execute a double-click in a pivot table cell | Charts and Charting in Excel | |||
Automate Add-in | Excel Discussion (Misc queries) | |||
Click on cell-calendar drops down-click on date-date fills cell. . | Setting up and Configuration of Excel |