Re: $$Excel-Macros$$ VB Code to open a worksheet based on a list of worksheet names

2016-01-12 Thread Bé Trần Văn
Click Button to Hyperlink to Worksheets. If more Add Worksheet, then Copy and Paste to Button ABOUT MAIN 2016-01-13 5:19 GMT+07:00 Rob Flott : > I have a workbook with nearly 200 worksheets. Each worksheet is named for > a specific retailer. > Included in this workbook is a sheet listing 75 of

$$Excel-Macros$$ VB Code to open a worksheet based on a list of worksheet names

2016-01-12 Thread Rob Flott
I have a workbook with nearly 200 worksheets. Each worksheet is named for a specific retailer. Included in this workbook is a sheet listing 75 of these retailers. I want to create the VB code that opens the sheet with the list of 75 retailers, selects the name and then finds the corresponding s