Can one correlate data betw/sheets ?

[Brightbelt]

Hello -
I'm new to this group as well. I'm on Excel 2003, Win XP Pro and I'm
fairly familiar with the excel interface, but probably still a newbie.
I'm doing a running balance, like a checkbook, with deposits and
withdrawals etc. I've set that up fine, but I'd like to be able to correlate
and continue data between sheets because I've set the worksheet up to have 8
sheets within it (if I'm using the wrong terminology, this is one (1) excel
worksheet file with 8 sheets within it - that's 8 sheet tabs at the bottom).
In specifics, I'd like to have , say, M2 of Sheet2 pick up the data/value of
the balance at the end of the former sheet, say, from L100 of Sheet1
automatically. Is this possible ?
I've also had similar issues with my tax expense statement where it would
come in handy to continue sum formulas between sheets.
I appreciate any help anyone could offer. I hope my terminology was clear
enough. Thanks,...Frank Bright
www.frankbright.com

 

[Paul B]

Brightbelt, in sheet 2 M2 put =Sheet1!L100, you can also put and = sign in
sheet 2 m2 and then click on sheet 1 and click in cell L100 and hit enter,
excel will put the formula in for you

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Brightbelt]

Thanks Paul !! I appreciate your help,...Frank

Brightbelt, in sheet 2 M2 put =Sheet1!L100, you can also put and = sign in
sheet 2 m2 and then click on sheet 1 and click in cell L100 and hit enter,
excel will put the formula in for you

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Roger Govier]

Hi Frank

Just for your future reference, you have a Workbook with 8 Worksheets within
it. Each tab is a Worksheet.

To extract data from one sheet to another, in any formula just refer to the
Sheet name ,followed by an exclamation mark, followed by the cell reference
e.g. on Sheet2 in cell A1 =Sheet1!A100 will pick up the value from cell A100
on sheet1. This can be done easily by typing an = sign in the cell you want
the formula, then navigating with your mouse to the Sheet and cell whose
value you want to pick up. Excel will create the formula for you.
Whenever you refer to Sheet names which have spaces in the name, then
enclose the name within single quotes e.g. 'My Sheet'!A1

You can Sum values across multiple sheets with =SUM(Sheet1:Sheet8!A1) will
sum all values from A1 in sheets 1 to 8.

I wondered why you needed to have 8 sheets, when you are only using 100 rows
on each. Is there some reason why you can't just continue on the same sheet?