Hi,
I'm new to excel, perhaps someone will help me.
What I want to do is to make a monthly expences list. At the moment got sth
like this:
FEBRUARY
---------------------------------------------------------------
days 1 2 3 4 5 6
....
---------------------------------------------------------------
Shopping 60$ 20$
Entertainment
Books 15$
....
What I want to do is to divide some categories on a subcategories, to make
it look like
FEBRUARY
---------------------------------------------------------------
days 1 2 3 4 5 6
....
---------------------------------------------------------------
Shopping 60$ 20$
food 20$
clothing 35$
others 5$
Entertainment
Books 15$
....
This is simple, BUT I'm not capable to do something like drop down menu,
like when you click on "Shopping" drop list appear, there's possibility to
fill cells
AND hide them when they are not needed at the moment (to look like my first
graph)
What is important for me, there needs to be possibility to edit drop list,
to make
it easy adding news subcategories
Is this possible to do in Excell?
thanks
Peter
Bob Phillips - 17 Feb 2007 12:02 GMT
I would create lines for all possible sub-categories of shopping, and then
group those rows, Data>Group & Outline, Group...

Signature
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
> Hi,
>
[quoted text clipped - 42 lines]
> thanks
> Peter
eusenet - 17 Feb 2007 12:13 GMT
>I would create lines for all possible sub-categories of shopping, and then
>group those rows, Data>Group & Outline, Group...
perfect! thanks a lot
Sandy Mann - 17 Feb 2007 13:42 GMT
I don't know if this is what you are looking for but highlight a number of
unused cells under the Shopping label, (insert then if need be) and then
select Data > Group and Outline > Group.
You can then hide/unhide the rows by the + or - buttons that will be
created.
The Shopping Total can be the SUM() of the grouped cells below the Total.

Signature
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk
> Hi,
>
[quoted text clipped - 42 lines]
> thanks
> Peter