I have a workbook with 20 sheets and I need to write a macro that will copy a
range from the previous page using a command button.
Example: CmdButton1= copy range Sheet1!A1:B5 into Sheet2!A1:B5, Cmd
Button2= copy Sheet2!A1:B5 into Sheet3!A1:B5, etc. I was writing an
individual macro for each sheet but there must be a more efficient way to do
it. Is there a "copy previous page range" into ActiveSheet?
Thanks a million for any help you can give me.
Regards,