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?

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?

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?