| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
= cell in another worksheet
Hi,
I have created a Master worksheet and would like other sheets to update if information is entered into the Master. I have typed =Master!A8 but instead of the information in cell A8 in sheet Master appearing in my cell the text =Master!A8 appears. Why is this happening? I am sure I have used this formula before. have I missed something or is there something wrong with the formatting behind it? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
= cell in another worksheet
It sounds like the cell if formatted as TEXT.
Select the cell in question Format it as GENERAL With the cell still selected hit function key F2 then hit ENTER -- Biff Microsoft Excel MVP "Nikki" wrote in message ... Hi, I have created a Master worksheet and would like other sheets to update if information is entered into the Master. I have typed =Master!A8 but instead of the information in cell A8 in sheet Master appearing in my cell the text =Master!A8 appears. Why is this happening? I am sure I have used this formula before. have I missed something or is there something wrong with the formatting behind it? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
= cell in another worksheet
Yeah just figured that one out. Thanks
"T. Valko" wrote: It sounds like the cell if formatted as TEXT. Select the cell in question Format it as GENERAL With the cell still selected hit function key F2 then hit ENTER -- Biff Microsoft Excel MVP "Nikki" wrote in message ... Hi, I have created a Master worksheet and would like other sheets to update if information is entered into the Master. I have typed =Master!A8 but instead of the information in cell A8 in sheet Master appearing in my cell the text =Master!A8 appears. Why is this happening? I am sure I have used this formula before. have I missed something or is there something wrong with the formatting behind it? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
= cell in another worksheet
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Nikki" wrote in message ... Yeah just figured that one out. Thanks "T. Valko" wrote: It sounds like the cell if formatted as TEXT. Select the cell in question Format it as GENERAL With the cell still selected hit function key F2 then hit ENTER -- Biff Microsoft Excel MVP "Nikki" wrote in message ... Hi, I have created a Master worksheet and would like other sheets to update if information is entered into the Master. I have typed =Master!A8 but instead of the information in cell A8 in sheet Master appearing in my cell the text =Master!A8 appears. Why is this happening? I am sure I have used this formula before. have I missed something or is there something wrong with the formatting behind it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| populate cell on worksheet 2 if text is red on worksheet 1 | Excel Worksheet Functions | |||
| How do I take a cell in one worksheet and add it into the formula in a different worksheet in the same workbook? | Excel Worksheet Functions | |||
| copy data in a cell from worksheet A to worksheet B | Excel Discussion (Misc queries) | |||
| How do I copy a date in a worksheet cell to another worksheet? | Excel Worksheet Functions | |||
| How can I link cell colours from worksheet to worksheet/workbook? | Excel Worksheet Functions | |||
Hybrid Mode
