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:

FilePage Setup...SheetColumns to repeat at left:$A:$A

Regards,
Fred.

"K. Blount-Hill" wrote in message
...
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.