Enter data on one sheet duplicate on another?

M

Michele

I am working with one workbook with three tabbed sheets all formatted
identically. This is a registration for a forum so the first and last name
will be same on all sheets but other data different.

Can I format to enter name once on first sheet...and it will appear on the
other two. I realize I could just keep cliping and pasting, but I am trying
to save key strokes. Any chance?
 
T

tim m

If you double left click on the cell you want to refer to put in the = and
then go to your original sheet and click on the cell you want to refer to and
then hit enter. You should end up with a formula that looks something like
this =Sheet1!A1

This tells it to look on sheet 1 at cell A1 and show whatever is in that cell.
 
M

Michele

Thank you! That was very helpful! I accidently hit that it wasn't on the
screen but it was just what I needed to know! Thanks!
 
Top