sub totalling

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Sub totalling

Sub totalling

resolvedResolved · Low Priority · Version 2003

Bob has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Project Intro Intermediate course
Project Advanced course

Sub totalling

How do you nest them

RE: sub totalling

Hi Bob

Thank you for your question

First let me apologise for the delay in responding to your post

Could you clarify your question for me, perhaps including a concrete example so I can place the question in context

Regards

Stephen

RE: sub totalling

Hi Bob,

How are you?

This question has now been left unattended for a while.

We like to keep down the large number of active forum posts we receive.

As we are waiting for your response for further information to help resolve your issue, we will be automatically marking this question as resolved in the next 5 days (unless you post a follow-up within that time).

We look forward to hearing from you.

Thank you.
Regards, Rich

RE: sub totalling

The attached sheet done during the training sub-totals on Country and City, there are four boxes to click to expand or colapse the data.
I can do city or country but not both together. How did we 'nest' the sub totalling one within the other?

best regards

Bob

Attached files...

bobSome addresses.xls

Wed 20 May 2009: Automatically marked as resolved.


 

Excel tip:

Highlighting only Text cells

To select onlt text value cells in a spreadsheet, click on Edit-Go to(F5)


In the Go To dialog box, click Special.
In the Go To Special dialog box, select Constants.
Click OK.

View all Excel hints and tips


Server loaded in 0.07 secs.