Previous Topic Next Topic

Take Reference from previous sheet automatically

Closed
SANO - Jan 1, 2015 at 07:32 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - 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 response

Answer 1 / 1
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 262
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