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.
|