Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 ============================================ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |