O
Olaf Mackenzie
I have a workbook that is a schedule. I enter the
detailed information for a number of different groups of
people and would like to form a summary sheet that lists
the activities of the principal participant of each
group.
If i simply cut and paste the information is not updated
as i change it. WHat i need to do is to be able to link
information from one cell to another. However if i write
text into a box and it overlaps a numbesr of cells, for
example an activity that lasts several hours, and then
create alink from that cell or croup of cells with text
in them then i get a 0 in the cells that have nothing in
them and this ovedrwrites the text.
Any ideas?
Olaf
detailed information for a number of different groups of
people and would like to form a summary sheet that lists
the activities of the principal participant of each
group.
If i simply cut and paste the information is not updated
as i change it. WHat i need to do is to be able to link
information from one cell to another. However if i write
text into a box and it overlaps a numbesr of cells, for
example an activity that lasts several hours, and then
create alink from that cell or croup of cells with text
in them then i get a 0 in the cells that have nothing in
them and this ovedrwrites the text.
Any ideas?
Olaf