Hello All,
Since I got such great help the first time around, will give it another go. Am putting a macro together that will create an index sheet for the report being opened. Nothing fancy, just finds the sheet names, copies the names, and creates links to those specific sheets within the workbook. What I would like to do is to add an additional line which will add a title to the index based on the title in the summary sheet. I have the following formula which, if inserted directly into a cell will give the disired results
I would like to be able to add this into the VBA code but have not had any success adding it using a line such as:
An error is generated when trying to run the above code and looking for alternatives if possible...
Bookmarks