Hi,

i need your help please.

I need a macro which read out the last (in this file Pos. 4) or a user seleted Position (Position 2 or 1).
The macro should read out the cells in this row and put the data into the defined cells in Sheet2.

in this case:
Data from B4[Sheet1] copy to B5[Sheet2]
Data from C4[Sheet1] copy to C7[Sheet2]
Data from D4[Sheet1] copy to E6[Sheet2]

The cells in Sheet2 are the same every time. Only the data (the row) in Sheet1 does change.
I add more Position every week in Sheet1.

Can anyone help me please?

Book1.xlsm