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

grouping sheets

ResolvedVersion 2011 (Mac)

Joseph has attended:
Excel Intermediate course
Excel Advanced course

Grouping Sheets

Hi,

I am building a database of suppliers for a company. There are 35 categories for example Brickwork,fencing, roadwork,architects etc.

Currently I have a summary sheet and 35 sheets open, each with a list of suppliers details. The 35 sheets fall under 7 main categories ie Internal, external, Professional services etc.

Is it possible to see 7 tabs at the bottom (main categories) so it's not too clustered, then when I click on say professional services i expands to show the underlying 5 subcategories.

Kind of layering/grouping the sheets.

Hope this is clear!

Thanks

Joe

RE: Grouping Sheets

Hi Joe, thanks for your query. The quickest way to achieve this would be with macros. Simply record yourself hide and unhiding the individual collections and then attach the macros to the quick access toolbar for ease of use. If you specifically want the functionality you mention you'll definitely have to go down the full blown code route I'm afraid.

Hope this helps,

Anthony

Mon 21 May 2012: Automatically marked as resolved.

Excel tip:

Using an equal (=) sign that isn't part of a formula

Before you type the equal sign, type an apostrophe: '
Then type your equal sign: = (and anything else you want to add after your equal sign)
Press ENTER.

(the apostraphe will disappear

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.