0
When you have a long list of numbers that are in natural groups, subtotals can be handy. You could have a list of numbers for sales throughout the year and put in subtotals for each month for example. You might have subtotals for each sales person or sub totals for each region or anything like that. All you need is to have the numbers and something to distinguish them into their different groups and have them in the order of their groups. Then you can create subtotals, as Excel will be able to detect the end of one group and the start of the next and then put a subtotal in for the group.
What else can I help you with?
How do you make Microsoft Excel talk?
This code will make Excel speak the content of the first cell:Sub SayThisCell()Cells(1, 1).SpeakEnd Sub
How do you lock a Microsoft Excel workbook to always open on the same worksheet and cell instead of on whichever worksheet or cell you were on when you last saved the file?
Private Sub Workbook_Open() Worksheets(1).Activate End Sub In VB worksheet
What are two words an Excel macro ends with?
End Sub.
Can a handyman sub out work to a contractor if job totals more than 500.00?
I would just break the job up into many 500$ jobs. Handyman it all.
In excel 2007 what is the menu off of a right arrow?
When you right-click, you will get a sub-menu appropriate for the context on which you clicked.
Can we display real time label using the vba in the Excel form?
IF YOU WISH EXCEL LABEL TO DISPLAY DATE AND TIME YOU CAN USE THE ONTIME FUNCTION. WHEN THE USERFORM INTITIALISES YOU CAN OPEN THE FUNCTION THAT WE WILL CREATE FOR THIS FUNCTION FOR EG RELOAD SUB USERFORM_INITIALISE() CALL RELOAD END SUB THEN YOU CAN CREATE THE SUB WHICH WILL UPDATE THE LABEL SUB RELOAD() DIM INT AS DATE INT = NOW INT= NOW + TIMEVALUE("00:00:01") APPLICATION.ONTIME INT,"RELOAD",,TRUE USERFORM.LABEL1.CAPTION = TIME END SUB THE SUB RELOAD WILL BE DONE EVERY SECOND AND SO THE LABEL WILL GET a NEW LABEL TIME EVERY SECOND SO THIS FUNCTION WILL ACT LIKE A SECONDS CLOCK IN EXCEL. END SUB
What is an Excel submenu?
It is a menu that is part of another menu. So you can have main menu and when you choose one of its items and it shows another menu, that is a sub-menu. It is more a part of versions of Excel up to version 2003. So, for example, on the Edit menu there was a sub-menu with options for Fill.
What are the sub types of pie chart in Excel?
Pie, 3D pie, pie of pie, bar of pie and doughnut.
If you point to a button that includes an arrow Excel displays a which is a list of additional commands associated with the selected command?
sub-menu
Where would you go to get a sub?
sub way or publix
Who would like to do sub 4 sub?
preston
How do you organize Microsoft Word documents?
by making folders and sub-folders where you saving your word documents on hard drive
