Select Cells from Column A which are hyperlinked to Sheets

Ben - Nov 15, 2015 at 11:47 PM

I would like to do the following:

1.Select Cells from Column A in "Index" Sheet which are already hyperlinked to Tab Sheets in the current workbook.

2.If the sheets in Column A of "Index" Sheet can be selected then, the selected sheets needs to be saved as a separate workbook.

3.The destination of workbook then needs to be saved in the last line of Column A of "Index" Sheet.