Embed Sheet

[Johnnyb]

I am working on a sheet with approx 3000 entries, The first colum
stores the company name, second stores customer number and so on.
company can have many customer numbers which causes alot of compan
name repitition in the first column. Is it possible to embed this shee
into another one and use a combo box filled with all the company name
to access the specific areas of the embedded sheet?

Any help would be greatly appreciated.

Thankyou,

Johnny

 

[jeff]

Hi,

I think this sounds do-able - first look at
Chip Pearson's page:
http://www.cpearson.com/excel/duplicat.htm#ExtractingUniqu
e

for ideas on getting the unique values together.

jeff

 

[Johnnyb]

I have got the unique values together now and populated a combo box, Ho
can i select a company name in the combo box to show me all relate
information for that company in an embedded sheet?

Regard's,

Johnny