I'm working on a spreadsheet for our production system. Our system contains tabs that can be renamed to pretty much anything, which we refer to as tab aliases. The spreadsheet I'm working on will have a worksheet for each tab and I want to rename the worksheets based on the tab aliases. For example, the production tab default of "Warehouse" can have an alias of something like "W/House". I have the alias in cell X5. Of course, the / is an invalid character for a worksheet name so I need a macro that will rename the worksheet to what is in cell X5 and if there are any special characters, automatically change them to a hyphen.
Any help would be greatly appreciated!
Any help would be greatly appreciated!