May 19 2022 09:57 AM
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.
May 19 2022 10:57 AM
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.