Provide for the coders:
Version of the program
Microsoft Excel for Office 365 ProPlus – Excel version: 1908
What I need it to do
I need a VBA macro that will create a new sheet with all Page names, Page Numbers, and Page URLs from another sheet.
In theory it would work something like this...