- Views 816
What you get with this Hourlie
When you are fed up with giving lot of time just to find the correct sheet.
When you want to speed up your working; then we have the solution for you i.e. very simple and yet very time saving. "The Automated Linked Index Sheet".
-This will create an index list of all the sheets in the workbook with sheet names.
-The sheet names would be automatically add sheet names to index page in sequential order.
-All the sheets will have back to index link.
-The index will update every time you go to index page (Means any sheet added to the workbook will be automatically updated in the index sheet in sequential order).
Now no problem in moving back and forth and time wastage. You have the most efficient and organised workbook.
What the Seller needs to start the work
Follow 3 step instruction
1)Add sheet in your workbook and name it "Index"
2)Right click on the sheet and click view code.
3)Copy the code and save it. Its done.
Note: When adding this to your workbook, keep 1st row of every sheet empty.
Just send me the workbook and I will do it for you