Take Reference from previous sheet automatically
Closed
SANO
-
Jan 1, 2015 at 07:32 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Jan 2, 2015 at 06:41 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Jan 2, 2015 at 06:41 AM
Related:
- Take Reference from previous sheet automatically
- Little alchemy cheat sheet - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- How to take screenshot of excel sheet - Guide
- Google sheet right to left - Guide
- Pc restarts automatically - Guide
1 response
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
Jan 2, 2015 at 06:41 AM
Jan 2, 2015 at 06:41 AM
Hello Sano,
Just an example of what you could do.
Say that you have a balance in sheet1 to carry forward to sheet2 . The balance in sheet1 is in, say, cell A1 but you need to carry forward the balance into cell B2 in sheet2.
In cell B2 in sheet2, enter the equals (=) symbol. Go back to sheet1 and click on cell A1 to highlight it and then press "enter' on your keyboard.
You will then find your balance brought forward to cell B2 in sheet2. To see the formula that transferred the balance, click on cell B2 and you will see the formula in the function bar. The formula should be:-
=Sheet1!A1
I hope this helps you.
Regards,
vcoolio.
Just an example of what you could do.
Say that you have a balance in sheet1 to carry forward to sheet2 . The balance in sheet1 is in, say, cell A1 but you need to carry forward the balance into cell B2 in sheet2.
In cell B2 in sheet2, enter the equals (=) symbol. Go back to sheet1 and click on cell A1 to highlight it and then press "enter' on your keyboard.
You will then find your balance brought forward to cell B2 in sheet2. To see the formula that transferred the balance, click on cell B2 and you will see the formula in the function bar. The formula should be:-
=Sheet1!A1
I hope this helps you.
Regards,
vcoolio.