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" wrote in
message ...
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 !!!!