Fill cells in different worksheets with data extracted form one particular worksheet

Dear Forum Members,

I'm quite new to VBA Excel and i'm still struggling to find my way out.
I have a workbook containing initially 2 worksheets namely 'Participants' and 'Planning'
In the 'Participants' sheet I added a number of details about the participants and depending on the period that I will use the workbook i have to amend the 'Planning' worksheet according - Column A & B, all other columns remain the same.

Following this I have to create a seperate 'Planning' worksheet for each participant and name the sheet with the participant's name.
I managed to do all these using VBA (see attached).

My issue now is that in each of the newly created worksheets, i need to replace the wording ' Branch 1' & 'Branch 2' with the corresponding branch name found in worksheet 'Participants' - column H & I

It would be nice if the script could work with the button I placed in sheet 'Participant' - 'Create Worksheets'.
This will avoid having multiple buttons in the worksheet

Thanks you beforehand for your comments and feedback.

Kind regards,

Shaeto

Hi,

try this file: Test 1.xlsm

contains:

Please Login or Register  to view this content.