I have created a spreadsheet that cells will be marked with an X in order to
track a persons particiapation in different activities. I would like to link
all of these cells to the header cell for that column which will have a
comment attached. The purpose is so that if the cell is marked I would like
that to tell Excel to type the comment instead of the X. Is this possible.

You could have another set of columns that link to the first set, and
show those for printing. For example, if your marked columns are D:F,
enter the following formula in cell G2:

=IF(E2="X",E$1,"")

Copy the formula across to column I
Copy down to the last row of data

Hide columns D:F when printing

Tammy wrote:
I have created a spreadsheet that cells will be marked with an X in order to
track a persons particiapation in different activities. I would like to link
all of these cells to the header cell for that column which will have a
comment attached. The purpose is so that if the cell is marked I would like
that to tell Excel to type the comment instead of the X. Is this possible.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html