Enter data on one sheet duplicate on another?
 

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?

Enter data on one sheet duplicate on another?
 

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.

"Michele" wrote:

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?

Enter data on one sheet duplicate on another?
 

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!

"tim m" wrote:

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.

"Michele" wrote:

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?