To select a sheet from a list of sheets sorted in ascending order,
install the ChooseSheet.xla Add in:
1. Download the ChooseSheet.xla add-in by join to ExcelTip newsletter (see left column).
2. Save the downloaded ChooseSheet.xla file in any folder.
3. From the Tools menu, select Add-Ins, and then click Browse.
4. Locate and select the ChooseSheet.xla file and click OK.
5. From the Add-ins available, check the ChooseSheet.xla box, and then click OK.
6. To select a sheet from the sorted sheets list, click the new Choose Sheet icon (number 7 in the Regular toolbar).
Screenshot // Selecting a Sheet from a Sorted Sheets List
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
"Hello,
I'd like to move between sheets using VBA code. I want to search each sheet for the same data to find witch sheet it's on.
Ben "
anybody know how to get a macro to paste data from a cell inot the worksheet name tab. The data from the cell will be different every time to macro is run, the macro currently pastes the data from when i first recorded it, instead of re-checking the cell and pasting the new data.