A translation of my earlier enquiry - which is probably baffling most people!
I want my macro to copy a row from worksheet A and paste it into a row in worksheet B.
The problem is that the rows in Worksheet B change daily - so I need to instruct the macro to find the appropriate row in Worksheet B first to paste the data in.
Worksheet B contains people's names all the way down column A. All I want my macro to do is "find Joe Blogg's name in column A and paste the data in cells C:E of his row (i.e. a couple of cells to the right of joe blogg's name).
Can anyone help?
I want my macro to copy a row from worksheet A and paste it into a row in worksheet B.
The problem is that the rows in Worksheet B change daily - so I need to instruct the macro to find the appropriate row in Worksheet B first to paste the data in.
Worksheet B contains people's names all the way down column A. All I want my macro to do is "find Joe Blogg's name in column A and paste the data in cells C:E of his row (i.e. a couple of cells to the right of joe blogg's name).
Can anyone help?