Hi,

Would anyone know how to write a vba code that does the following:

copies sheet1 (a1:a10)
pastes it to sheet2 (a1:a10)

copies sheet1 (b1:b10)
pastes it to sheet3 (a1:a10)

your help is greatly appreciated!