Hi all
wondering if i can get some assistance...i require a macro where the
1) "index" sheet will open always open
2) user selects name from cell E10 of company name
b) once user name selects name, the macro will open the company listed main sheet and any other data sheets that relate to drop down name
3) "index" sheet, if cell E11 = yes, then copy all active tabs open of selected company (exlcuding index and details) and create them in new workbook
can someone kindly assist? thx
i have attached sample
FYI: the details page would have input of all company names and their respective additional tabs that are hidden/unhidden when company name selected. also, more company names will be added
Bookmarks