Greetings ,

I have a task which I am unfamiliar with.

First of all I have 2 workbooks open
lets say the workbook names are Workbook 1 and workbook 2
.
And the macro should consist of the following:

1- to select a value from a drop down list in workbook 1 which also consists of 2 options in cell B2 (Hybrid: PV+BESS) and (Hybrid: BESS only)
2- if the option (Hybrid: PV+BESS) is chosen then also set the dropdown list in another workbook 2 to the same value which is in cell D71 and if the option in workbook1 is chosen to be (Hybrid: BESS only) then set the dropdown list in workbook 2 to the same value chosen.

3- after selection there are values from Cell C4 to G4 in workbook 1 that should be copied using macro to workbook 2 in certain cells ,and after each cell copied (example: cell c4 from workook1 is copied to cell B11 in workbook2 then the macro should activate another ready macro from workbook 2 which is already a functional macro ... then some values should be copied back into certain cells) this is how the macro should work.

What I am trying to clarify is that there should be a loop from cell c4 to G4 but within the loop there also should be other commands.