Hiding sections

[timsims]

Hi,

I'm playing around with a spreadsheet at the moment and I'm trying to hide a section unless it's required. I want to put an option in if the following section is required, if yes is selected it shows up but if no is selected it remains hidden.

Excel Workbook
	A	B	C	D	E	F
25	Edging
26		-
27	Type of edging	Total linear metres	Edging type	Cost per metre		Total
28	15mm		Straight	1.22		0.00
29	15mm		Straight	1.22		0.00
30	15mm		Straight	1.22		0.00
31	15mm		Straight	1.22		0.00
32	Edging glue		N/A	1.00	N/A	0.00
33					Sub total =	0.00
34
Secsi

Excel 2007

Cell Formulas
Range	Formula
A28	=VLOOKUP(B4,B122:C128,2,FALSE)
A29	=VLOOKUP(B4,B122:C128,2,FALSE)
A30	=VLOOKUP(B4,B122:C128,2,FALSE)
A31	=VLOOKUP(B4,B122:C128,2,FALSE)
D28	=INDEX(B116:F118,MATCH(C28,A116:A118,0),MATCH(B4,B115:F115))
D29	=INDEX(B116:F118,MATCH(C28,A116:A118,0),MATCH(B4,B115:F115))
D30	=INDEX(B116:F118,MATCH(C28,A116:A118,0),MATCH(B4,B115:F115))
D31	=INDEX(B116:F118,MATCH(C28,A116:A118,0),MATCH(B4,B115:F115))
F28	=SUM(B28*D28)
F29	=SUM(B29*D29)
F30	=SUM(B30*D30)
F31	=SUM(B31*D31)
F32	=SUM(B32*10)
F33	=SUM(F28+F29+F30+F31+F32)

Anyone able to help?

 

[Damon Ostrander]

Hi Timsims,

You can use Data > Group to hide/unhide blocks of rows manually. But if you want the hiding/unhiding to occur automatically based on Yes/No entered in a cell or checkbox control, you will need a few lines of VBA code. But you didn't specify where you are entering yes/no or what blocks of code you want hidden so I can't be more specific.

Damon