How do I auto populate a column with information from another colu
 

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.

How do I auto populate a column with information from another colu
 

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.

How do I auto populate a column with information from another colu
 

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.