I would now like the macro to perform the following 3 tasks
After the worksheet has been copied to the supplier meetings status sheet I would like the macro to rename the active sheet as the value present in cell H2.
Create a hyper-link on the new copied sheet using the value in H2. (see example). The hyper-link will send the user to cell A1 in the active sheet.
I would then like the macro to copy (as links) a number of the value's from the now copied sheet to "meetings.task.status.log"
You will see an example of the cells I would like to copy and paste as links. These values must be pasted as live links.
As this is a repeat process, each time the links will be copied from a new copied sheet, they must be added as a new row in the meetins.task.status.log and must not overwrite the current rows
I've attached an example copy of the original workbook "original.source" and copy of the "Supplier Meetings Status". for testing purposes.
Note: I have assigned the macro to button "copy to log" on the "original.source" file.