| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Show in a Cell the Value for another Cell
I have a cell(B6) in sheet1 with a value anda I want to show this value in a
cell(C6) in sheet2. What I do was: in the cell(C6) in sheet2 I put: ='sheet1'!B6 This worked, but if I insert a line upper the line 6 in the sheet1, the function goes like this: ='sheet1'!B7 Anyone can help me? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i assign cell A1 to show the current cursor cell in Excel? | Excel Discussion (Misc queries) | |||
| format cell to show leading zeros and make cell a three digit fiel | Excel Worksheet Functions | |||
| In adjacent cell, show last date modified of target cell. | Excel Discussion (Misc queries) | |||
| enter a time into a cell, have the cell show two times the entry | Excel Worksheet Functions | |||
| Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Discussion (Misc queries) | |||
Threaded Mode
