Thanks, preferred first method as there are more columns linked to column A
in each sheet. If I re-enter only the name the corresponding data in other
columns will not move. First method worked great as there were just specific
cells on each worksheet that needed correcting.


"Biff" wrote:

Just a little clarification:

Double click in each of the name cells then hit enter.

You only need to do this on any one of the sheets not all sheets. That's why
they've been grouped! What you do to one sheet will be done to all.

In essence, what you're doing is re-entering the name in the cell and it
will be re-entered to the same cell in each sheet.

Biff

"Biff" wrote in message
...
Even better:

Select and group the 12 sheets in question.

Double click in each of the name cells then hit enter.

This may sound like a lot to go through but it should only take a min! How
fast can you double click and hit enter?

Make sure you ungroup the sheets when done.

Biff

"Ali" wrote in message
...
Hi, I have approx 12 sheets. On each Column A is a list of 87 names.
Some
changes have been made to later lists but I need to correct all lists to
eb
the same. How do I ensure that the SAME name appears on the SAME line
across
all sheets as the final sheet reads totals from a formula. Checking each
list manually is taking too long. Thanks