3-D Worksheet referencing

  • Thread starter Ross M. Greenberg
  • Start date
R

Ross M. Greenberg

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
 
R

Ross M. Greenberg

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
 
D

davesexcel

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

Now Sheet1A1 now referrs to Sheet2B1
 
T

Tom Ogilvy

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

='Master Data'!A1

will link to A1 in Master Data.
 
R

Ross M. Greenberg

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


Thank you, Dave!!

Ross
 
Top