I have a spreadsheet showing current employees each week together with various standard columns for rates of pay etc.

1st Column employees number
2nd Column Employee name
3rd etc days of the week etc

I can run a report off the system to show the updated list of employees each week so it will leave out any leavers and include any new starters. At the moment I manually update this list.

Can a macro be set up so I can simply paste the new information from the weekly report to update the existing list of employees?

(Please note that I am a beginner as far as macros are concerned so a "dummys" guide would be appreciated).

thanks very much