I need excel help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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 :)
 
Back
Top