Thread: How to populate a combo box with filtered data from a named range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dan dungan dan dungan is offline
external usenet poster
  
Posts: 411
Default How to populate a combo box with filtered data from a named range
Hi,

Using Excel 2000, I have two worksheets: tblCurstomerApproved, and
tblContacts, populated from an access database.

Here's a sample of the tblCurstomerApproved data:

id Customer
7 AEROSPACE SYSTEMS
5 AERO-TECH ENGINEERING


Here's a sample of tblContacts data:
CoId CntctId Email FName LName Wphone
5 35 Bob Li 858-748-7301
5 224 Rick Jorgenson 858-748-7301
858-748-7319
7 84 Marsha Benter 507-235-3355 224 218-333-0112
7 312 Joan Jet 507-235-3355 260 218-333-0112






Reply With QuoteReply With Quote