Lists in Visual Basic - Excel

[bg_ie]

Hi there,

I'm working in Excel 2002, SP3.

I have the data with the following format -

APC (Name : APC77) (Value : 200)
APC (Name : APC3157) (Value : XXX)
APC (Name : APC1406) (Value : 2000)
APC (Name : APC1426) (Value : 90)
APC (Name : APC74) (Value : 250)
APC (Name : APC3680) (Value : 10)
APC (Name : APC3683) (Value : 100)

BPC (Name : 3318) (Value : A) (Desc : (old))
BPC (Name : 3143) (Value : A) (Desc : (new))
BPC (Name : 3526) (Value : A) (Desc : (new))
BPC (Name : 3678) (Value : A) (Desc : (new))
BPC (Name : 3131) (Value : A) (Desc : (new))
BPC (Name : 3244) (Value : B) (Desc : (old))
BPC (Name : 3334) (Value : A) (Desc : (old))

I wish to use two lists, one called APC_List and the second called
BPC_List. I'd like to use the name as a key to the Value and Desc, if
possible. What datatypes might I use to achieve this? How would you
implement this?

Thanks for your help,

Barry.

 

[merjet]

I think you need to be more specific about what you want. How is, or
how do want, your data structured in cells? What does "use the name as
key" mean w.r.t. cells, VBA code, or UserForms?

Hth,
Merjet