| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Duplicating cell value between worksheets
A simple question by example. Say I have a value in ws1, cell a31, of 345.
I would like whatever the value of that cell to also be shown in ws 2, cell g50. How do I do that? -- Dennis |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Duplicating cell value between worksheets
Hi!
In Sheet2 G50 enter: =Sheet1!A31 Biff "Dennis" wrote in message ... A simple question by example. Say I have a value in ws1, cell a31, of 345. I would like whatever the value of that cell to also be shown in ws 2, cell g50. How do I do that? -- Dennis |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Duplicating cell value between worksheets
Hi Dennis
In Sheet2 cell G50 enter =Sheet1!A31 -- Regards Roger Govier "Dennis" wrote in message ... A simple question by example. Say I have a value in ws1, cell a31, of 345. I would like whatever the value of that cell to also be shown in ws 2, cell g50. How do I do that? -- Dennis |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Duplicating cell value between worksheets
Biff,
Thanks you very much. I told you it was a simple question. It works. -- Dennis "Biff" wrote: Hi! In Sheet2 G50 enter: =Sheet1!A31 Biff "Dennis" wrote in message ... A simple question by example. Say I have a value in ws1, cell a31, of 345. I would like whatever the value of that cell to also be shown in ws 2, cell g50. How do I do that? -- Dennis |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Duplicating cell value between worksheets
=if(sheet1!a31="","",sheet1!a31)
(there's a difference in what you'll see if sheet1, cell A31 is empty.) Dennis wrote: A simple question by example. Say I have a value in ws1, cell a31, of 345. I would like whatever the value of that cell to also be shown in ws 2, cell g50. How do I do that? -- Dennis -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Duplicating cell value between worksheets
Roger,
Thank you for your prompt response to my question. It feels great to have the answer after spending hours trying to research this by reading manuals. Newsgroups and responders are wonderful. -- Dennis "Roger Govier" wrote: Hi Dennis In Sheet2 cell G50 enter =Sheet1!A31 -- Regards Roger Govier "Dennis" wrote in message ... A simple question by example. Say I have a value in ws1, cell a31, of 345. I would like whatever the value of that cell to also be shown in ws 2, cell g50. How do I do that? -- Dennis |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Duplicating cell value between worksheets
Got it! Thanks much.
Dennis -- Dennis "Dave Peterson" wrote: =if(sheet1!a31="","",sheet1!a31) (there's a difference in what you'll see if sheet1, cell A31 is empty.) Dennis wrote: A simple question by example. Say I have a value in ws1, cell a31, of 345. I would like whatever the value of that cell to also be shown in ws 2, cell g50. How do I do that? -- Dennis -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
| Use the same cell from many worksheets to create a chart? | Charts and Charting in Excel | |||
| how do I sum the same cell from multiple worksheets? | Excel Worksheet Functions | |||
| add the same cell on several worksheets to another worksheet | Excel Worksheet Functions | |||
| HOW DO I REFERENCE A CELL FROM THE RESULTS OF TWO WORKSHEETS | Excel Discussion (Misc queries) | |||
Linear Mode
