| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell in Sheet one automatically going to a cell in sheet two
Hey again...I have two sheets in my book. I would like the amount that is in E26 in sheet 1 to automatically pull up in G13 of sheet 2. Can I put in a formula to do that? Thanks. -- Roz ------------------------------------------------------------------------ Roz's Profile: http://www.excelforum.com/member.php...o&userid=29746 View this thread: http://www.excelforum.com/showthread...hreadid=497636 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell in Sheet one automatically going to a cell in sheet two
In G13 of sheet two, enter:
=Sheet1!E26 HTH, Paul "Roz" wrote in message ... Hey again...I have two sheets in my book. I would like the amount that is in E26 in sheet 1 to automatically pull up in G13 of sheet 2. Can I put in a formula to do that? Thanks. -- Roz ------------------------------------------------------------------------ Roz's Profile: http://www.excelforum.com/member.php...o&userid=29746 View this thread: http://www.excelforum.com/showthread...hreadid=497636 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell in Sheet one automatically going to a cell in sheet two
In cell G13 of Sheet 2 put this formula
=Sheet1!E26 Vaya con Dios, Chuck, CABGx3 "Roz" wrote: Hey again...I have two sheets in my book. I would like the amount that is in E26 in sheet 1 to automatically pull up in G13 of sheet 2. Can I put in a formula to do that? Thanks. -- Roz ------------------------------------------------------------------------ Roz's Profile: http://www.excelforum.com/member.php...o&userid=29746 View this thread: http://www.excelforum.com/showthread...hreadid=497636 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell in Sheet one automatically going to a cell in sheet two
Cool beans, Thanks a bunch!! -- Roz ------------------------------------------------------------------------ Roz's Profile: http://www.excelforum.com/member.php...o&userid=29746 View this thread: http://www.excelforum.com/showthread...hreadid=497636 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Identify repeated cell entries in multiple sheet workbook as you . | Excel Discussion (Misc queries) | |||
| Excell:Move from any Cell Sheet 1 to any cell Sheet 2 etc. | Excel Worksheet Functions | |||
| Cell linked to a range of cell values in different sheet | Excel Discussion (Misc queries) | |||
| Changing Cell formats to date fields automatically | Excel Worksheet Functions | |||
| How do I automatically rename a sheet with the contents of a cell. | Excel Discussion (Misc queries) | |||
Linear Mode
