COPYING CELL INFO FROM ONE WORKSHEET TO ANOTHER

New Contributor

How do I copy something automatically from one cell in a worksheet to same cell in different work sheet.

 

I have 2 work sheets.  I want what I do in one worksheet to copy into the next worksheet.

example: 

worksheet one= I plug in a number in cell A1

worksheet two= i want that same number to copy into cell A1 from the worksheet one.

1 Reply

@salpyapple 

enter data in 2 sheets.JPG

You can try to select sheet1 and sheet2 and then enter data. If sheet1 is your active sheet you can press the ctrl key and click on sheet2 with the mouse. Now both sheets are active as shown in the above picture. As long as both sheets are active every entry in any cell is entered in the other sheet as well.