ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How to copy from one worksheet to another (https://www.excelbanter.com/new-users-excel/148465-how-copy-one-worksheet-another.html)

Luis[_2_]

How to copy from one worksheet to another
 
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


CLR

How to copy from one worksheet to another
 
In cell A2 of Sheet 2, put this formula and copy it on over to O2,

=Sheet1!A2

Vaya con Dios,
Chuck, CABGx3



"Luis" wrote:

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




All times are GMT +1. The time now is 08:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com