3-D Worksheet referencing
 

Can somebody help me please?
I.
I'm an Excel newbie.

And I want to have one master worksheet with all of my income, my expenses,
and other calculations. I then want to have multiple other worksheets with
rent calculations for different potential apartments.

I want to be able to refer to the master worksheet calculations in the
individual apartment worksheets. I think it is done with "Insert- define".
Am I right? And if so, how do I do this?

Thanks!

Ross

3-D Worksheet referencing
 

hre's a couple of sites to get started in excel

http://tutorials.freeskills.com/free...tutorials.html

http://www.mvps.org/dmcritchie/excel....htm#tutorials


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=539643

3-D Worksheet referencing
 

Thanks Dave!

Some of the links -- quite a few in fact -- are dead links. FYI.

I'm not entirely a newbie in excel: I have everything set up except for
referencing the cells on a different worksheet: and am wondering just how
the heck to do precisely that.

Ross

"davesexcel" wrote
in message ...

hre's a couple of sites to get started in excel

http://tutorials.freeskills.com/free...tutorials.html

http://www.mvps.org/dmcritchie/excel....htm#tutorials


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile:
http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=539643

3-D Worksheet referencing
 

Hi,
If you were in Sheet1A1 hit the = and goto Sheet2B1 then enter...

Now Sheet1A1 now referrs to Sheet2B1


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=539643

3-D Worksheet referencing
 

If the sheet you want to reference has a tab name of Master Data

='Master Data'!A1

will link to A1 in Master Data.

--
Regards,
Tom Ogilvy


"Ross M. Greenberg" wrote in message
...
Thanks Dave!

Some of the links -- quite a few in fact -- are dead links. FYI.

I'm not entirely a newbie in excel: I have everything set up except for
referencing the cells on a different worksheet: and am wondering just how
the heck to do precisely that.

Ross

"davesexcel"
wrote
in message ...

hre's a couple of sites to get started in excel

http://tutorials.freeskills.com/free...tutorials.html

http://www.mvps.org/dmcritchie/excel....htm#tutorials


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile:
http://www.excelforum.com/member.php...o&userid=31708
View this thread:
http://www.excelforum.com/showthread...hreadid=539643

3-D Worksheet referencing
 

That sure in hell was easy!! Worked like a champ!


Thank you, Dave!!

Ross

"davesexcel" wrote
in message ...

Hi,
If you were in Sheet1A1 hit the = and goto Sheet2B1 then enter...

Now Sheet1A1 now referrs to Sheet2B1


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile:
http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=539643