I need a excel template to have all below options. This can be done manually if the file is simple and neat. Where in sometime we get the huge data which contains 40+ tabs in one excel and thats where my life is going hectic.
1. First I have to rename the tabs based on the list I have in the first page (Summary).
2. Then as I have 40+ excel sheet(tabs), some might be hidden by the user. Excel sometime doesnt work in our way - In terms of unhinding, you shld do it manually only in excel by right clicking.
3. Also, some time particular select tab name should be renamed based on request.
So is that possible to create a excel Add in like this.
1. Icon for - Renaming the tabs based on the excel list in first sheet.
2.Icon for - Selecting the sheet (which shld have multiple selection option) and unhiding in one shot.
3. Icon for - Popup to write your desired prefix or sufix on tab rename for selected tabs.
Please help me with this. Example attached here