| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting data from one Worsheet to Another Worksheet with common link value | Excel Discussion (Misc queries) | |||
| Referencing a dropdown box on a worksheet | Excel Discussion (Misc queries) | |||
| Referencing a worksheet name | Excel Worksheet Functions | |||
| Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
Linear Mode
