assign a sheet from an external spreadsheet to a combo box

birniegw

New Member
Joined
Feb 17, 2004
Messages
16
I am trying to find a way to attach a worksheet from an external workbook to a choice selected from a combo box. Ideally this combo box is located in the Rollup workbook that has links to the external workbooks for individual depts. When the dept# is selected and want the dept's sheet displayed.
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Watch MrExcel Video

Forum statistics

Threads
1,118,674
Messages
5,573,598
Members
412,537
Latest member
Mohamed_5966
Top