How to copy from one worksheet to another

[luis.a.roman]

I have a worksheet that contains several worksheets. I would like to
get the information on tab Sheet 1 and copy cells (A2:O2) in a tab
name Sheet 2.

Can someone share the code to do that ? Or inform me where can I go to
read about it in order to accomplish this.

Your collaboration will be appreciated.

Luis

 

[Opinicus]

I have a worksheet that contains several worksheets. I would like to
get the information on tab Sheet 1 and copy cells (A2:O2) in a tab
name Sheet 2.

1. Define the cells (A2:O2) in sheet 1. (Put the cursor in A2 and holding
down the left control key, use the right arrow to move to O2.)
2. Press control-C.
3. Click on sheet 2.
4. Move the cursor to the cell you want to start copying the information to.
5. Press control-V.