I see your point. In A1 enter:
=INDIRECT("C" & COLUMN()+9)
and copy across. This is only one formula rather than many.


The +9 is a bit artificial and will need to be adjusted if the list does not
start in C10
--
Gary's Student
gsnu200707


"John Gilmer" wrote:


"Gary''s Student" wrote in message
...
Lets say the column heading are in cells C10 thru C20 (modify to meet your
requirements)

In A1 thru K1 enter:

=C10
=C11
=C12
=C13
=C14
=C15
=C16
=C17
=C18
=C19
=C20

--
Gary's Student
gsnu200707


That's what I have been doing.

I'm VERY lazy (and somewhat geek oriented) so I want the C3....C50 entries
to be made automatically. Aside from saving work it will also reduce the
chance of a data entry error.