Sort of subsheet
 

I know you cannot have subsheets in Excel as it is not a hierarchical system.
I wondered if there was anyway of generating a similar end result though.

I have a list of engineers and I record the mileage they travel each week. I
am going to have another worksheet that records the private mileage they have
travelled, how much they have paid for that fuel and what MPG they claimed it
at. It would make life much easier if on the first worksheet there was a +
button next to each name that displayed the engineers corresponding figures
when clicked. Possible?

Sort of subsheet
 

On the Data menu there is an option Group and Outline, which allows
you to group rows or columns together which can be expanded with a +
and reduced with a -. This seems to be what you are looking for. Have
a look in Excel Help Index for Outline (though it is not very
detailed).

Hope this helps.

Pete

On Aug 6, 12:05*pm, Pyrite wrote:
I know you cannot have subsheets in Excel as it is not a hierarchical system.
I wondered if there was anyway of generating a similar end result though.

I have a list of engineers and I record the mileage they travel each week.. I
am going to have another worksheet that records the private mileage they have
travelled, how much they have paid for that fuel and what MPG they claimed it
at. It would make life much easier if on the first worksheet there was a +
button next to each name that displayed the engineers corresponding figures
when clicked. Possible?

Sort of subsheet
 

Once again you help me out of a jam. Thanks alot Pete_UK

"Pete_UK" wrote:

On the Data menu there is an option Group and Outline, which allows
you to group rows or columns together which can be expanded with a +
and reduced with a -. This seems to be what you are looking for. Have
a look in Excel Help Index for Outline (though it is not very
detailed).

Hope this helps.

Pete

On Aug 6, 12:05 pm, Pyrite wrote:
I know you cannot have subsheets in Excel as it is not a hierarchical system.
I wondered if there was anyway of generating a similar end result though.

I have a list of engineers and I record the mileage they travel each week.. I
am going to have another worksheet that records the private mileage they have
travelled, how much they have paid for that fuel and what MPG they claimed it
at. It would make life much easier if on the first worksheet there was a +
button next to each name that displayed the engineers corresponding figures
when clicked. Possible?

Sort of subsheet
 

Well, that's nice to know (I thought your name was familiar) - thanks
for feeding back.

Pete

On Aug 6, 2:23*pm, Pyrite wrote:
Once again you help me out of a jam. Thanks alot Pete_UK