software

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 quot;Insert-gt; definequot;.
Am I right? And if so, how do I do this?

Thanks!

Ross

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

tutorials.freeskills.com/free...tutorials.html

www.mvps.org/dmcritchie/excel....htm#tutorials--
davesexcel------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=539643Thanks 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

quot;davesexcelquot; gt; wrote
in message ...
gt;
gt; hre's a couple of sites to get started in excel
gt;
gt; tutorials.freeskills.com/free...tutorials.html
gt;
gt; www.mvps.org/dmcritchie/excel....htm#tutorials
gt;
gt;
gt; --
gt; davesexcel
gt;
gt;
gt; ------------------------------------------------------------------------
gt; davesexcel's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31708
gt; View this thread: www.excelforum.com/showthread...hreadid=539643
gt;

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

Now Sheet1A1 now referrs to Sheet2B1--
davesexcel------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=539643If 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 Ogilvyquot;Ross M. Greenbergquot; gt; wrote in message
...
gt; Thanks Dave!
gt;
gt; Some of the links -- quite a few in fact -- are dead links. FYI.
gt;
gt; I'm not entirely a newbie in excel: I have everything set up except for
gt; referencing the cells on a different worksheet: and am wondering just how
gt; the heck to do precisely that.
gt;
gt; Ross
gt;
gt; quot;davesexcelquot; gt;
wrote
gt; in message ...
gt; gt;
gt; gt; hre's a couple of sites to get started in excel
gt; gt;
gt; gt; tutorials.freeskills.com/free...tutorials.html
gt; gt;
gt; gt; www.mvps.org/dmcritchie/excel....htm#tutorials
gt; gt;
gt; gt;
gt; gt; --
gt; gt; davesexcel
gt; gt;
gt; gt;
gt; gt; ------------------------------------------------------------------------
gt; gt; davesexcel's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=31708
gt; gt; View this thread:
www.excelforum.com/showthread...hreadid=539643
gt; gt;
gt;
gt;
That sure in hell was easy!! Worked like a champ!Thank you, Dave!!

Ross

quot;davesexcelquot; gt; wrote
in message ...
gt;
gt; Hi,
gt; If you were in Sheet1A1 hit the = and goto Sheet2B1 then enter...
gt;
gt; Now Sheet1A1 now referrs to Sheet2B1
gt;
gt;
gt; --
gt; davesexcel
gt;
gt;
gt; ------------------------------------------------------------------------
gt; davesexcel's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31708
gt; View this thread: www.excelforum.com/showthread...hreadid=539643
gt;