| 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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Show in a Cell the Value for another Cell
=INDIRECT("Sheet1!B6")
-- Gary''s Student - gsnu200827 "LefepeCalambau" wrote: 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Show in a Cell the Value for another Cell
Thanks Gary. This works great.
just an observation, the correct syntax is =INDIRECT("'Sheet1'!B6") "Gary''s Student" escreveu: =INDIRECT("Sheet1!B6") -- Gary''s Student - gsnu200827 "LefepeCalambau" wrote: 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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Show in a Cell the Value for another Cell
I can assure you that Gary''s Student has been using Excel (and advising
others) for plenty long enough to be aware that if the sheet name had spaces in it he would need the single quotes around the sheet name, but he also knows that without a space in the sheet name he doesn't need the single quotes, so the syntax he used was perfectly valid for the question you asked. -- David Biddulph "LefepeCalambau" wrote in message ... Thanks Gary. This works great. just an observation, the correct syntax is =INDIRECT("'Sheet1'!B6") "Gary''s Student" escreveu: =INDIRECT("Sheet1!B6") -- Gary''s Student - gsnu200827 "LefepeCalambau" wrote: 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? |
| Reply |
| 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) | |||
Linear Mode
