| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Reference Change
I have constructed a document by laying out a template on worksheet 1 and inputting info on worksheet 2. To input new information I insert a row however the corresponding formula cells on worksheet 1 change row number to follow the already inserted line. Protecting worksheet one does not work. I want to find a way to ensure that the values always apply to the same cell number on workshhet 2 i.e. cell =A1 always stays the same regardless of if I insert a line. Please help!! -- MDW ------------------------------------------------------------------------ MDW's Profile: http://www.excelforum.com/member.php...o&userid=32769 View this thread: http://www.excelforum.com/showthread...hreadid=526018 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell Reference Change
so the formula in sheet 2 should look like this =Sheet1!$A$1
and no metter how many rows you will insert in sheet 2 you`ll get the value from sheet1 cell A1 -- M.A. "MDW" wrote in message ... I have constructed a document by laying out a template on worksheet 1 and inputting info on worksheet 2. To input new information I insert a row however the corresponding formula cells on worksheet 1 change row number to follow the already inserted line. Protecting worksheet one does not work. I want to find a way to ensure that the values always apply to the same cell number on workshhet 2 i.e. cell =A1 always stays the same regardless of if I insert a line. Please help!! -- MDW ------------------------------------------------------------------------ MDW's Profile: http://www.excelforum.com/member.php...o&userid=32769 View this thread: http://www.excelforum.com/showthread...hreadid=526018 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell Reference Change
Marijus.......is your response supose to be helpful?? You must work for Microsoft!!?? Someone must be able to help..........please!!! -- MDW ------------------------------------------------------------------------ MDW's Profile: http://www.excelforum.com/member.php...o&userid=32769 View this thread: http://www.excelforum.com/showthread...hreadid=526018 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell Reference Change
I believe you want Indirect. Like this maybe:
=INDIRECT("'sheet2'!a1") -- Kevin Vaughn "MDW" wrote: I have constructed a document by laying out a template on worksheet 1 and inputting info on worksheet 2. To input new information I insert a row however the corresponding formula cells on worksheet 1 change row number to follow the already inserted line. Protecting worksheet one does not work. I want to find a way to ensure that the values always apply to the same cell number on workshhet 2 i.e. cell =A1 always stays the same regardless of if I insert a line. Please help!! -- MDW ------------------------------------------------------------------------ MDW's Profile: http://www.excelforum.com/member.php...o&userid=32769 View this thread: http://www.excelforum.com/showthread...hreadid=526018 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell Reference Change
Kevin Vaughn thanks for your reply. This issue has been driving me crazy. This does solve my problem for the most part however using INDIRECT has caused another problem. On several of the cells I do not want a 0 to appear where a value is not detailed. I have tried the following but it still shows a zero. =INDIRECT(IF("sheet2!a1"<0.001," ","sheet2!a1")). Any idea how I get around this problem? Thanks again. -- MDW ------------------------------------------------------------------------ MDW's Profile: http://www.excelforum.com/member.php...o&userid=32769 View this thread: http://www.excelforum.com/showthread...hreadid=526018 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell Reference Change
Kevin, Thanks A whole bunch for your help. You are a star!!!!!  -- MDW ------------------------------------------------------------------------ MDW's Profile: http://www.excelforum.com/member.php...o&userid=32769 View this thread: http://www.excelforum.com/showthread...hreadid=526018 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell Reference Change
You're welcome.
-- Kevin Vaughn "MDW" wrote: Kevin, Thanks A whole bunch for your help. You are a star!!!!! -- MDW ------------------------------------------------------------------------ MDW's Profile: http://www.excelforum.com/member.php...o&userid=32769 View this thread: http://www.excelforum.com/showthread...hreadid=526018 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Reference with Range Name | Excel Worksheet Functions | |||
| Getting contents of a cell when cell reference is in the sheet | Excel Discussion (Misc queries) | |||
| how do I format a cell reference to move as source changes | Excel Worksheet Functions | |||
| change cell shading whenever contents different from previous cell | Excel Discussion (Misc queries) | |||
| How do I change a cell from absolute reference to relative referen | Excel Discussion (Misc queries) | |||
Linear Mode
