hierarchys - can you build an elegant hierarchy using vba

hi all

a question to all you experts - is it possible to build a basic hierarchy
using vba ( I know Vb has an object in its toolbox )

or does anyone have an ocx etc ??

my sheet has a range of product values and i would like to build a drill up
and drill down function usinf standard excel

if you reply - thanks in advance


--
C Ward - a novice user !!!!

i should explain that my lsit is simple in nature

lets say


4 mm bar
8 mm bar
12 mm bar

all reporting up to bars which reports up to Total Steel

i.e a classic OLAP hierarcy ( sort of analysis server territory )

how can we do this in excel
--
C Ward


"christopher ward" wrote:

> hi all
>
> a question to all you experts - is it possible to build a basic hierarchy
> using vba ( I know Vb has an object in its toolbox )
>
> or does anyone have an ocx etc ??
>
> my sheet has a range of product values and i would like to build a drill up
> and drill down function usinf standard excel
>
> if you reply - thanks in advance
>
>
> --
> C Ward - a novice user !!!!

experts - I assume excel can not do this ...............

can anyone help ??

--
C Ward


"christopher ward" wrote:

> hi all
>
> a question to all you experts - is it possible to build a basic hierarchy
> using vba ( I know Vb has an object in its toolbox )
>
> or does anyone have an ocx etc ??
>
> my sheet has a range of product values and i would like to build a drill up
> and drill down function usinf standard excel
>
> if you reply - thanks in advance
>
>
> --
> C Ward - a novice user !!!!

What is it that you want your drill up/down function to do?

Tim

"christopher ward" <christopherward@discussions.microsoft.com> wrote in
message news:FA96D029-ABBA-4FAB-94AF-DFE7361A4ECE@microsoft.com...
> experts - I assume excel can not do this ...............
>
> can anyone help ??
>
> --
> C Ward
>
>
> "christopher ward" wrote:
>
>> hi all
>>
>> a question to all you experts - is it possible to build a basic hierarchy
>> using vba ( I know Vb has an object in its toolbox )
>>
>> or does anyone have an ocx etc ??
>>
>> my sheet has a range of product values and i would like to build a drill
>> up
>> and drill down function usinf standard excel
>>
>> if you reply - thanks in advance
>>
>>
>> --
>> C Ward - a novice user !!!!

i have a sheet with a number of product codes as an example
using a hierarchy tool i want to create parents and grandparents - i.e a
basic olap hierarchy on a dimension ( im used to Oracle OLAP doing this
naturally ) but i suspect i need an OCX control to help me - it must have
been done before


--
C Ward


"Tim Williams" wrote:

> What is it that you want your drill up/down function to do?
>
> Tim
>
> "christopher ward" <christopherward@discussions.microsoft.com> wrote in
> message news:FA96D029-ABBA-4FAB-94AF-DFE7361A4ECE@microsoft.com...
> > experts - I assume excel can not do this ...............
> >
> > can anyone help ??
> >
> > --
> > C Ward
> >
> >
> > "christopher ward" wrote:
> >
> >> hi all
> >>
> >> a question to all you experts - is it possible to build a basic hierarchy
> >> using vba ( I know Vb has an object in its toolbox )
> >>
> >> or does anyone have an ocx etc ??
> >>
> >> my sheet has a range of product values and i would like to build a drill
> >> up
> >> and drill down function usinf standard excel
> >>
> >> if you reply - thanks in advance
> >>
> >>
> >> --
> >> C Ward - a novice user !!!!
>
>
>

Christopher,

What does this translate to in terms of Excel ? I understand the concept
but what should the resulting excel file be able to *do* ? Is it a tool for
creating the relationships, displaying the relationships, or what ?

Tim.

--
Tim Williams
Palo Alto, CA


"christopher ward" <christopherward@discussions.microsoft.com> wrote in
message news:FABCF318-651C-4015-B53C-6F307A42D9C4@microsoft.com...
> i have a sheet with a number of product codes as an example
> using a hierarchy tool i want to create parents and grandparents - i.e a
> basic olap hierarchy on a dimension ( im used to Oracle OLAP doing this
> naturally ) but i suspect i need an OCX control to help me - it must have
> been done before
>
>
> --
> C Ward
>
>
> "Tim Williams" wrote:
>
> > What is it that you want your drill up/down function to do?
> >
> > Tim
> >
> > "christopher ward" <christopherward@discussions.microsoft.com> wrote in
> > message news:FA96D029-ABBA-4FAB-94AF-DFE7361A4ECE@microsoft.com...
> > > experts - I assume excel can not do this ...............
> > >
> > > can anyone help ??
> > >
> > > --
> > > C Ward
> > >
> > >
> > > "christopher ward" wrote:
> > >
> > >> hi all
> > >>
> > >> a question to all you experts - is it possible to build a basic
hierarchy
> > >> using vba ( I know Vb has an object in its toolbox )
> > >>
> > >> or does anyone have an ocx etc ??
> > >>
> > >> my sheet has a range of product values and i would like to build a
drill
> > >> up
> > >> and drill down function usinf standard excel
> > >>
> > >> if you reply - thanks in advance
> > >>
> > >>
> > >> --
> > >> C Ward - a novice user !!!!
> >
> >
> >

Dear Tim

sorry if i confussed the issue - all i want is to have a list of product
codes
in a data range lets say B10:B59 and be able to say this code reports to
Bars or Plates - i.e build a parent child relationship of course many levels
deep so i need my hierarchy to have a level number , a parent or child
relationship , a description - thus at any stage i can drill up or down on
any given member in a list box for example

i guess im trying to find an OCX or another item to add to the VBA toolkit

chris

--
C Ward


"Tim Williams" wrote:

> Christopher,
>
> What does this translate to in terms of Excel ? I understand the concept
> but what should the resulting excel file be able to *do* ? Is it a tool for
> creating the relationships, displaying the relationships, or what ?
>
> Tim.
>
> --
> Tim Williams
> Palo Alto, CA
>
>
> "christopher ward" <christopherward@discussions.microsoft.com> wrote in
> message news:FABCF318-651C-4015-B53C-6F307A42D9C4@microsoft.com...
> > i have a sheet with a number of product codes as an example
> > using a hierarchy tool i want to create parents and grandparents - i.e a
> > basic olap hierarchy on a dimension ( im used to Oracle OLAP doing this
> > naturally ) but i suspect i need an OCX control to help me - it must have
> > been done before
> >
> >
> > --
> > C Ward
> >
> >
> > "Tim Williams" wrote:
> >
> > > What is it that you want your drill up/down function to do?
> > >
> > > Tim
> > >
> > > "christopher ward" <christopherward@discussions.microsoft.com> wrote in
> > > message news:FA96D029-ABBA-4FAB-94AF-DFE7361A4ECE@microsoft.com...
> > > > experts - I assume excel can not do this ...............
> > > >
> > > > can anyone help ??
> > > >
> > > > --
> > > > C Ward
> > > >
> > > >
> > > > "christopher ward" wrote:
> > > >
> > > >> hi all
> > > >>
> > > >> a question to all you experts - is it possible to build a basic
> hierarchy
> > > >> using vba ( I know Vb has an object in its toolbox )
> > > >>
> > > >> or does anyone have an ocx etc ??
> > > >>
> > > >> my sheet has a range of product values and i would like to build a
> drill
> > > >> up
> > > >> and drill down function usinf standard excel
> > > >>
> > > >> if you reply - thanks in advance
> > > >>
> > > >>
> > > >> --
> > > >> C Ward - a novice user !!!!
> > >
> > >
> > >
>
>
>

i should also add if I have a hierarchy on products i need code to add or
delete or move any given item in the hierarchy - this functionality will be
added to a system i have written in Excel 2003 and needs to be user friendly
- so far the systems works but i see no easy way for hierarchy generation
over many dimensions even if they only have single hierarchys - pivot table
does not help me - i need raw codde to create the relationships thats easy to
use - i can discuss offline if needed


--
C Ward


"Tim Williams" wrote:

> Christopher,
>
> What does this translate to in terms of Excel ? I understand the concept
> but what should the resulting excel file be able to *do* ? Is it a tool for
> creating the relationships, displaying the relationships, or what ?
>
> Tim.
>
> --
> Tim Williams
> Palo Alto, CA
>
>
> "christopher ward" <christopherward@discussions.microsoft.com> wrote in
> message news:FABCF318-651C-4015-B53C-6F307A42D9C4@microsoft.com...
> > i have a sheet with a number of product codes as an example
> > using a hierarchy tool i want to create parents and grandparents - i.e a
> > basic olap hierarchy on a dimension ( im used to Oracle OLAP doing this
> > naturally ) but i suspect i need an OCX control to help me - it must have
> > been done before
> >
> >
> > --
> > C Ward
> >
> >
> > "Tim Williams" wrote:
> >
> > > What is it that you want your drill up/down function to do?
> > >
> > > Tim
> > >
> > > "christopher ward" <christopherward@discussions.microsoft.com> wrote in
> > > message news:FA96D029-ABBA-4FAB-94AF-DFE7361A4ECE@microsoft.com...
> > > > experts - I assume excel can not do this ...............
> > > >
> > > > can anyone help ??
> > > >
> > > > --
> > > > C Ward
> > > >
> > > >
> > > > "christopher ward" wrote:
> > > >
> > > >> hi all
> > > >>
> > > >> a question to all you experts - is it possible to build a basic
> hierarchy
> > > >> using vba ( I know Vb has an object in its toolbox )
> > > >>
> > > >> or does anyone have an ocx etc ??
> > > >>
> > > >> my sheet has a range of product values and i would like to build a
> drill
> > > >> up
> > > >> and drill down function usinf standard excel
> > > >>
> > > >> if you reply - thanks in advance
> > > >>
> > > >>
> > > >> --
> > > >> C Ward - a novice user !!!!
> > >
> > >
> > >
>
>
>

You can do quite a bit with XL and VBA as long as you have the time and/or
money to invest in it.

For a drilldown example see
PivotChart Drill-down
http://www.tushar-mehta.com/excel/so...own/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <FA96D029-ABBA-4FAB-94AF-DFE7361A4ECE@microsoft.com>,
christopherward@discussions.microsoft.com says...
> experts - I assume excel can not do this ...............
>
> can anyone help ??
>
>