I need excel help

R

rick silva

I am trying to have data that I type in 1 cell also automatically appera in
another ... example .. if I type 123.00 in cell b6 on sheet one, I would like
it to appear also in cell b6 on sheet 3 .. can this be done
 
K

Klatuu

This newsgroup is for Access. You should ask your question in an Excel
newsgroup.
 
S

SteveS

Hi Rick,

Since I'm more of an excel whiz trying to learn access, and have gotten so
much out of these pages, I'm happy to help somebody else for a change!

On Sheet 3, cell b6 use the formula "=sheet1!b6"
Be sure to include the exclamation point after the sheet name.

Note: You can copy the formula as is across adjacent cells, and it will
automatically adjust the column and row reference, or you can place "$"
before either the column and/or the row referece to keep that one static.

(So, "=sheet1!$b6" in b6 copied to cell c6 will result in the formula
"=sheet1!$b6, whereas copied to cell b7 will result in the formula
"=sheet1$b7". Hope that makes sense - if you play around with it a little
you'll know what I mean.
 
R

rick silva

Thank-you, it was very helpful. I tried the copy thing and kept getting b6,
but ended up editing the cell numbers. no big deal, it worked,,thank-you very
much ... another member out here answered me by saying i was asking the
question in the wrong group .... wow, boo hoo, wahhhhhhh .. I appreciate you
answering me and helping me out, it make me fell like i did when i first came
on line years ago when people out here really did help each other :)
 
Top