How do I get all the text that I type into Column A on one page to auto fill
into the corresponding row in Column K on another page?

I am building a chart that has a list of individuals' names and
characteristics of them. I've found that all the columns will not fit on one
page, so I will have several pages each with different column headings and
characteristics, but all the pages need the first columns to have the same
information - the list of individuals' names. And I will be constantly
adding names to the list, so I don't want to have to always go and manually
format the columns in every page all the time.

By "pages", do you mean separate worksheets? If so, in column K, you want a
formula like:

=sheet1!k1

And copy it down as far as needed.

However, I suspect there's a better solution. You can have Excel repeat
certain columns on each page. Use:

File>Page Setup...>Sheet>Columns to repeat at left:>$A:$A

Regards,
Fred.

"K. Blount-Hill" <(E-Mail Removed)> wrote in message
news:2D062DEC-15FC-41D0-A90F-(E-Mail Removed)...
> How do I get all the text that I type into Column A on one page to auto
> fill
> into the corresponding row in Column K on another page?
>
> I am building a chart that has a list of individuals' names and
> characteristics of them. I've found that all the columns will not fit on
> one
> page, so I will have several pages each with different column headings and
> characteristics, but all the pages need the first columns to have the same
> information - the list of individuals' names. And I will be constantly
> adding names to the list, so I don't want to have to always go and
> manually
> format the columns in every page all the time.

Hi,

Highlight all the cells column A which you want to fill in column K and
click the Copy button.
Move the the second sheet select the first cell in Column K where you want
the item to appear and choose Edit, Paste Special, Paste Link.

If this helps, please click the Yes button,

Cheers,
Shane Devenshire

"K. Blount-Hill" wrote:

> How do I get all the text that I type into Column A on one page to auto fill
> into the corresponding row in Column K on another page?
>
> I am building a chart that has a list of individuals' names and
> characteristics of them. I've found that all the columns will not fit on one
> page, so I will have several pages each with different column headings and
> characteristics, but all the pages need the first columns to have the same
> information - the list of individuals' names. And I will be constantly
> adding names to the list, so I don't want to have to always go and manually
> format the columns in every page all the time.