Create a Contents Page in Excel Online with one click of a button!
Create a Contents Page in Excel Online with one click of a button!
Copy the supplied Office Script code into your Excel code pane. Give the Script a name. Run the Script. Et voila! You have created a contents page!
Find the code here : https://github.com/MrAnalyticals/Offi...
This script has been updated to include a more accurate Chart table creation process using the "getCellUnderChart" routine as supplied by Jan Karel Pieterse,, Excel MVP.