| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy a cell from sheet 1 to sheet 2
I need to copy the result in cell M75 - Sheet 1 to cell F8 in sheet 2 (same workbook) Need the formula. Thanks, Bob M. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy a cell from sheet 1 to sheet 2
hi
=Sheet1!M75 regards FSt1 "robert morris" wrote: I need to copy the result in cell M75 - Sheet 1 to cell F8 in sheet 2 (same workbook) Need the formula. Thanks, Bob M. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy a cell from sheet 1 to sheet 2
Thanks for the reply, one problem. When new numbers are entered into Sheet
1, they are updated on Sheet 1 but not on Sheet 2. Ideas? Bob M. "FSt1" wrote: hi =Sheet1!M75 regards FSt1 "robert morris" wrote: I need to copy the result in cell M75 - Sheet 1 to cell F8 in sheet 2 (same workbook) Need the formula. Thanks, Bob M. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy a cell from sheet 1 to sheet 2
On Sheet1, in M75, enter
100 On Sheet2, in F8, enter just an equal sign = Go back to Sheet1, and click in M75, and hit <Enter You should automatically be transported back to Sheet2, and you should see that 100 displayed in F8. Did that work? -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "robert morris" wrote in message ... Thanks for the reply, one problem. When new numbers are entered into Sheet 1, they are updated on Sheet 1 but not on Sheet 2. Ideas? Bob M. "FSt1" wrote: hi =Sheet1!M75 regards FSt1 "robert morris" wrote: I need to copy the result in cell M75 - Sheet 1 to cell F8 in sheet 2 (same workbook) Need the formula. Thanks, Bob M. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy a cell from sheet 1 to sheet 2
If you have entered the formula in Sheet2 F8 and value doesn't change when you
enter a new number in Sheet1 then I would check to make sure calculation mode is in Automatic. ToolsOptionsCalculation Gord Dibben MS Excel MVP On Thu, 18 Oct 2007 16:58:01 -0700, robert morris wrote: Thanks for the reply, one problem. When new numbers are entered into Sheet 1, they are updated on Sheet 1 but not on Sheet 2. Ideas? Bob M. "FSt1" wrote: hi =Sheet1!M75 regards FSt1 "robert morris" wrote: I need to copy the result in cell M75 - Sheet 1 to cell F8 in sheet 2 (same workbook) Need the formula. Thanks, Bob M. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy a cell from sheet 1 to sheet 2
This works! I still have some other numbers to enter. Will shout if I have
a problem. Thanks, Bob m. "RagDyer" wrote: On Sheet1, in M75, enter 100 On Sheet2, in F8, enter just an equal sign = Go back to Sheet1, and click in M75, and hit <Enter You should automatically be transported back to Sheet2, and you should see that 100 displayed in F8. Did that work? -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "robert morris" wrote in message ... Thanks for the reply, one problem. When new numbers are entered into Sheet 1, they are updated on Sheet 1 but not on Sheet 2. Ideas? Bob M. "FSt1" wrote: hi =Sheet1!M75 regards FSt1 "robert morris" wrote: I need to copy the result in cell M75 - Sheet 1 to cell F8 in sheet 2 (same workbook) Need the formula. Thanks, Bob M. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy a cell from sheet 1 to sheet 2
You're welcome, and appreciate the feed-back.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "robert morris" wrote in message ... This works! I still have some other numbers to enter. Will shout if I have a problem. Thanks, Bob m. "RagDyer" wrote: On Sheet1, in M75, enter 100 On Sheet2, in F8, enter just an equal sign = Go back to Sheet1, and click in M75, and hit <Enter You should automatically be transported back to Sheet2, and you should see that 100 displayed in F8. Did that work? -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "robert morris" wrote in message ... Thanks for the reply, one problem. When new numbers are entered into Sheet 1, they are updated on Sheet 1 but not on Sheet 2. Ideas? Bob M. "FSt1" wrote: hi =Sheet1!M75 regards FSt1 "robert morris" wrote: I need to copy the result in cell M75 - Sheet 1 to cell F8 in sheet 2 (same workbook) Need the formula. Thanks, Bob M. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 | Excel Worksheet Functions | |||
| Active Cell Copy And Paste Sheet to Sheet | New Users to Excel | |||
| copy cell from one sheet of worksheet to another sheet | Excel Discussion (Misc queries) | |||
| Copy text from same cell on every sheet to title sheet? | Excel Discussion (Misc queries) | |||
| relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
Linear Mode
