I have a limited ability with macros. I record them rather than write them.

What I'm trying to do is write a macro that will copy a cell value and paste
it to another sheet. Sounds simple. But the location it needs to be pasted is
a variable row with a fixed column.

I have a cell on sheet 1 (F7) which details the cell to go to in sheet 2
(R?C33) (?= variable row).

Can anyone advise.

Many thanks.