Does this call for a pivot table....how??

[mmenashe]

Im not sure if a pivot table is the best solution, but please advise

I have two sheets within the same workbook

Excel Workbook
	A	B
1	Name	Company
2	Jim Jones	ABC retailer
3	Nancy Smith	Widgets Forever
4	Earl Huffington	Best Steaks
Sheet1

Excel Workbook
	A	B
1	Email	Company
2	lball@abcretail.com	ABC Retailer
3	mfranco@abcretail.com	ABC Retailer
4	rhemmingway@abcretail.com	ABC Retailer
5	nsmith@widgetsforever.com	Widgets Forever
6	xtereso@beststeaks.net	Best Steaks
7	grdaly@beststeaks.net	Best Steaks
8	info@beststeaks.net	Best Steaks
Excel 2003 and Sheet2

Excel 2003



I would like for the right of each entry in Sheet1, to have a drop down box of the matching emails

the common item is the company name, but some companies may have multiple emails, and some many not have any

Id like a drop down box, so that I can put them together, and then just pick and choose the correct emails by looking at all the data

thanks

 

[alansidman]

This may be a viable solution:

http://www.bettersolutions.com/excel/EGH188/QE229212022.htm

Alan

 

[mmenashe]

thanks Alan,

Im looking into it, and I think the idea is right....
but it seems like a lot of manual data entry, which is exactly what I am trying to avoid

of course my non-example sheet has many many more entries and thousands of companies to sort through, so I cant type in the name for each company