Hi
I’ve a worksheet called abc 1, abc 2 abc 3 and so on until abc 30. I’d like to have a command button in each sheet and when clicked then excel automatically copy row d5:d10 into a5:a10 and copy e5:e10 into c5:c10 into the new sheet from the previous sheet sequentially.
Pls can someone help me.
thanks
I’ve a worksheet called abc 1, abc 2 abc 3 and so on until abc 30. I’d like to have a command button in each sheet and when clicked then excel automatically copy row d5:d10 into a5:a10 and copy e5:e10 into c5:c10 into the new sheet from the previous sheet sequentially.
Pls can someone help me.
thanks