Take Reference from previous sheet automatically

Closed
SANO - Jan 1, 2015 at 07:32 AM
vcoolio
Posts
1356
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
August 11, 2022
- Jan 2, 2015 at 06:41 AM
Hello,

I make a payroll settlement sheet in excel every week. When i make next week sheet i copy previous sheet & start working on it. Sometimes i have balance which has to be transferred from previous sheet.

Please tell me formula that automatically link previous sheet.

Regards
Samp

1 reply

vcoolio
Posts
1356
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
August 11, 2022
250
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.
0