View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default 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.