Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cell referencing
I am trying to create a worksheet that takes data entered into a matrix and
also puts it into a table elsewhere on the worksheet. I have doing this by using the =C7 type of reference in the table elsewhere so data I enter into C7 goes to the new cell, except it does not always work. Sometimes I get the contents of the matrix cell, which is what I want, other times I just get the "=C7" text. Also if I change a cell reference that works with a different cell it stops working. Anybody have any ideas as to whats going on? Thanks! ============================================ Gregory A. Wandless Chemist US Geological Survey MS 954 Reston, VA 20192 Email: Phone: (703) 648-6189 ============================================ |
#2
|
|||
|
|||
Hi Gregory
ensure that the "table elsewhere" is all formatted to general (click in an unused cell in a different worksheet and copy it, select your "table" and choose edit / paste special - add) -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Gregory A. Wandless" wrote in message ... I am trying to create a worksheet that takes data entered into a matrix and also puts it into a table elsewhere on the worksheet. I have doing this by using the =C7 type of reference in the table elsewhere so data I enter into C7 goes to the new cell, except it does not always work. Sometimes I get the contents of the matrix cell, which is what I want, other times I just get the "=C7" text. Also if I change a cell reference that works with a different cell it stops working. Anybody have any ideas as to whats going on? Thanks! ============================================ Gregory A. Wandless Chemist US Geological Survey MS 954 Reston, VA 20192 Email: Phone: (703) 648-6189 ============================================ |
#3
|
|||
|
|||
other times I just get the "=C7" text.
This is a symptom of having the cell formatted as text. Change it to General or some other format that is number-oriented. "Gregory A. Wandless" wrote: I am trying to create a worksheet that takes data entered into a matrix and also puts it into a table elsewhere on the worksheet. I have doing this by using the =C7 type of reference in the table elsewhere so data I enter into C7 goes to the new cell, except it does not always work. Sometimes I get the contents of the matrix cell, which is what I want, other times I just get the "=C7" text. Also if I change a cell reference that works with a different cell it stops working. Anybody have any ideas as to whats going on? Thanks! ============================================ Gregory A. Wandless Chemist US Geological Survey MS 954 Reston, VA 20192 Email: Phone: (703) 648-6189 ============================================ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create a variable column in cell reference | Excel Worksheet Functions | |||
How can I get a cell locked if the condition is false? | Excel Worksheet Functions | |||
Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |