Copy data between workbooks whit dropdown list as filter

[yschuerm]

I am looking to copy data from workbook A to workbook B. (This I can do).

The following part I can't get fixed.
In workbook A there is a drop down list with months of the year. Based on the selected month the correct row in workbook B needs to be found and data filled in on that row.

The Worksheet in both Workbooks have the same name HLO_BE_Data.

Workbook A

Month	Dropdown list (value June)
data	data	data
data	data	data
Total	Data to be copied to workbook B	Data to be copied to workbook B

<tbody>
</tbody>

Workbook B

Month	Planned	Actual
April	data	data
May	data	data
June	Workbook A Data B-Row	Workbook A Data C-Row

<tbody>
</tbody>