Cell referencing

  • Thread starter Gregory A. Wandless
  • Start date
G

Gregory A. Wandless

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: [email protected]
Phone: (703) 648-6189
============================================
 
J

JulieD

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)
 
D

Duke Carey

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.
 
G

Gregory A. Wandless

Thanks that did it. Seems to work now.

============================================
Gregory A. Wandless
Chemist
US Geological Survey
MS 954
Reston, VA 20192

Email: [email protected]
Phone: (703) 648-6189
============================================
 
Top