Home |
Search |
Today's Posts |
#1
|
|||
|
|||
linking text cells
I have a workbook where folks enter text, dates and put Xs in boxesin one
sheet (unprotected). These cells are linked to another sheet laid out to match a govt. form (protected, so folks cannot mess with the formatting). I want the text, dates and check boxes to flow from the first sheet to the second, and if no text is entered in the first sheet, nothing will appear in the second sheet. I am getting #VALUE! errors in some cells (not all), and in others the coding is appearing, not the text from the first sheet. I have tried to make sure each cell is formatted the same. Yet, I have a couple of cells that work perfectly, while others do not. Baffling! |
#2
|
|||
|
|||
linking text cells
Double paste to fix the formatting.
For example, copy A1 in sheet1. In sheet2 first select A1 and paste (to fix format) and then repaste/special with the link set. As far as formulae are concerned, when you paste into sheet, a formula is pasted, but the right values might not be available in the second sheet. Here you really have to paste/special as link. -- Gary''s Student "Pilgrim One" wrote: I have a workbook where folks enter text, dates and put Xs in boxesin one sheet (unprotected). These cells are linked to another sheet laid out to match a govt. form (protected, so folks cannot mess with the formatting). I want the text, dates and check boxes to flow from the first sheet to the second, and if no text is entered in the first sheet, nothing will appear in the second sheet. I am getting #VALUE! errors in some cells (not all), and in others the coding is appearing, not the text from the first sheet. I have tried to make sure each cell is formatted the same. Yet, I have a couple of cells that work perfectly, while others do not. Baffling! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup on large text in cells | Excel Worksheet Functions | |||
Text shown up in other cells everytime a text is entered in 1 cell | Excel Discussion (Misc queries) | |||
Macro or Formula to remove Text from Cells | Excel Worksheet Functions | |||
Combining & formatting cells with text - Excel 2002 | Excel Discussion (Misc queries) | |||
blank cells that include text | Excel Worksheet Functions |