Making the drop down list of a cell depend on another cell

[Jarrod]

I want to catagorise my spreadsheet entries, into seperate catagories eg:
Works/Services, Fundraising, Bar/Fridge, Misc, etc, with each of these
catagories having further classes inside them ie Fundraising contains:
Chocolates, Open Day, Donations etc. I want to do this so I can sort and
work out (using a pivot Table) income and expenses on each class.

Thanks for the Help, Jarrod

[JulieD]

Hi Jarrod

check out

http://www.contextures.com/xlDataVal02.html

I think this is what you're looking for.
--
Cheers
JulieD


julied_ng at hctsReMoVeThIs dot net dot au


"Jarrod" wrote:

> I want to catagorise my spreadsheet entries, into seperate catagories eg:
> Works/Services, Fundraising, Bar/Fridge, Misc, etc, with each of these
> catagories having further classes inside them ie Fundraising contains:
> Chocolates, Open Day, Donations etc. I want to do this so I can sort and
> work out (using a pivot Table) income and expenses on each class.
>
> Thanks for the Help, Jarrod

[Jarrod]

Thanks for the fast reply Julie, I managed to find the info (the one you
listed) just as you posted!
Regards
Jarrod

"JulieD" wrote:

> Hi Jarrod
>
> check out
>
> http://www.contextures.com/xlDataVal02.html
>
> I think this is what you're looking for.
> --
> Cheers
> JulieD
>
>
> julied_ng at hctsReMoVeThIs dot net dot au
>
>
> "Jarrod" wrote:
>
> > I want to catagorise my spreadsheet entries, into seperate catagories eg:
> > Works/Services, Fundraising, Bar/Fridge, Misc, etc, with each of these
> > catagories having further classes inside them ie Fundraising contains:
> > Chocolates, Open Day, Donations etc. I want to do this so I can sort and
> > work out (using a pivot Table) income and expenses on each class.
> >
> > Thanks for the Help, Jarrod