Any MS Excel experts here?

[Eric_Methven]

This is probably simple, but I can't find the answer.
I have created a simple workbook with twelve worksheets (Jan - Dec).
It is for keeping a track of my finances.
On worksheet 1 I have a cell and a formula which gives a balance at the bottom of the worksheet (C46) the formula (=SUM(C44-E44)) shows the value of the amount totalled.
On worksheet 2 I'd like to see that balance carried forward to the top of that worksheet but I don't know how to do it.
Can anyone tell me what I put in the formula bar to reflect the value in cell C46 on worksheet 1 into a new cell on worksheet 2?

Thanks in advance,

Eric

 

[resnikov]

=Sheet1!C46

where Sheet is the worksheets name in the bottom tab.

 

[Darkside]

what resnikov said

 

[Eric_Methven]

Blimey! That easy eh? Thanks guys!

 

[Harvestman]

Yup, as resnikov said. Actually, if you click in the cell where you want to put the value in the second worksheet, and just type =, then navigate to the first worksheet and click in cell C46, when you then go back to the second worksheet, the formula has been put in automatically. Just click <enter>. Easier than trying to remember where the ! goes in the formula.

 

[TeeDee]

Out of interest , what would you guys say is the best resource/book fro learning all things EXCEL??

 

[Trunks]

Another way is to copy the cell from worksheet 1, then go to your second sheet, click on the cell you want and hit "edit, paste special", at the bottom left of the window that has just popped up, click "paste link". You don't even have to deal with the formulas

 

[Dexter]

Out of interest , what would you guys say is the best resource/book fro learning all things EXCEL??

The idiot's guide is a very good place to start.

 

[Loenja]

google is your friend