LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Method to group lines

Hi,
I have this kind of sheet:
1?? AA1
2?? BB1
3?? CC1
3?? CC2
3?? CC3
3?? CC4
3?? CC5
2?? BB2
3?? CC6
3?? CC7
3?? CC8
1?? AA2
2?? BB3
3?? CC9
3?? CC10
3?? CC11

every rows it's a cell.
The first number is the level of depth.
How can I group group the rows by the level?
I need to use the function "Group" of Excel, so I can hide/show rows.
In this way I would see, before all the 1 then I expand them and I see
only the 2 and so on...

Thanks in advance for your help!

--
Ciao BlackSun
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Range.Group Method - group rows, not columns serhio[_2_] Excel Programming 1 May 7th 08 01:26 PM
How to roll up the group of lines? R-177 Excel Discussion (Misc queries) 2 June 1st 06 01:45 PM
group method - is there a collection jimm Excel Programming 1 February 26th 06 05:04 AM
Group Method failed in macro Ivan Excel Programming 0 September 3rd 05 06:07 AM
Remove lines from Group Box Lori Burton Charts and Charting in Excel 1 July 25th 05 06:50 PM


All times are GMT +1. The time now is 11:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"