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.