Hi Guys,

I need to have a sheet showing many rows of information but I'd like to
be able to expand/shrink the data by headings eg, heading of Cars, data
of 'Ford', 'Vauxhall' etc).

Depending on the choice from another sheet, I'd like the required rows
from each heading to be displayed (maybe with a '+' next to the heading
to display the rest of unshown data)... does this make sense??!!

I look forward to your response.

Richard.


--
fergusor
------------------------------------------------------------------------
fergusor's Profile: http://www.excelforum.com/member.php...fo&userid=6201
View this thread: http://www.excelforum.com/showthread...hreadid=554073

Data List Create List ...

You will have a dropdown arrow, not at "+".


"fergusor" wrote:


Hi Guys,

I need to have a sheet showing many rows of information but I'd like to
be able to expand/shrink the data by headings eg, heading of Cars, data
of 'Ford', 'Vauxhall' etc).

Depending on the choice from another sheet, I'd like the required rows
from each heading to be displayed (maybe with a '+' next to the heading
to display the rest of unshown data)... does this make sense??!!

I look forward to your response.

Richard.


--
fergusor
------------------------------------------------------------------------
fergusor's Profile: http://www.excelforum.com/member.php...fo&userid=6201
View this thread: http://www.excelforum.com/showthread...hreadid=554073