VB script in excel

[couper]

Hi
I have a excel document
On left side of the document there is a place which I don't understand.
I think it is made with vbscript.
How can I make something similar to it ?
how can I edit it?

Thanks...

http://netload.in/dateiMfH5qhuPS1/test.xls.htm

 

[Weaver]

What you have there is known as grouping and doesn't necessarily have anything to do with VB.

Check out Data -> Group and outline - it might require a little experimentation.

Sorry, but I'm not sure what the XL 2007 equivalent is.

 

[Leith Ross]

Hello couper,

What you see is the Group and Outline function. This is available to on the main menu under Data > Group and Outline. This can also be done through VBA.

Sincerely,
Leith Ross

 

[couper]

Thanks guys for the fast reply.
I'm using 2003 also.

Are there any document for how to use this function or I have to learn by trying?

 

[westconn1]

ADVERTISEMENT

check out the help

 

[Leith Ross]

Hello couper,

Microsoft Online has a good step by step tutorial http://office.microsoft.com/en-us/excel/HP052016411033.aspx

Sincerely,
Leith Ross

 

[couper]

I can not group rows like in the screenshot.
In that document I can create seperate groups but when I open a new excel file or one of my old excel files and select some rows then group first group is ok, but when I try to group another one they are added to the first one.
I can not make seperate groups...