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

[K. Blount-Hill]

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.

 

[Fred Smith]

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.

 

[Shane Devenshire]

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