Control Linked Workbooks Using Combo Box

[Du2good]

Have several workbooks and want to link all of them to a master. The master would have a combo box that is linked to a different workbook to select which OpID (individual’s) data to view. When a change is made to the combo box OpId, the master would show data from the linked workbooks for that particular OpID.

What would the code be to link the combo box (OpID) on the master workbook to a different workbook that would contain all of the OpIDs?

The master would show the different linked workbooks/ranges for the selected OpID.

There may be a better/easier/ different direction/method for all of this. I’m familiar with VBA and SQL in Access so I’m creating the tables in Access and export them to Excel. I can get the data easily, but when I use Excel I don’t know how to get all the data onto one tab when the OpID is determined by a combo box linked to a one of the workbooks.

 

[SkipVought]

Hi,

Consider MS Query. faq68-5829

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[Du2good]

OK, thats something I wasnt aware of. I'm changing directions though, going to pursue building everything in Access, with forms and reports.