Hi
function can not transfer formats. You have to apply the same format to
all rows manually

--
Regards
Frank Kabel
Frankfurt, Germany


Loroboro wrote:
Hello All,

I have a workbook with three sheets. On the three sheets are three
different forms. Currently I have it so that when i type data into
sheet1, there are cell links going to sheet2 and sheet3... and the
other two forms get parts of them filled out automatically. The
problem i have is that... the cell format is not held. I would like
the section of rows that are being edited to auto-fit and
wrap-text... Currently when i am typing in sheet1 form.. the cell
resizes but when i go to the other sheets (2 and 3) forms.. the text
just goes into the cell and keeps going out of the cell..

any ideas would be appreciated

thanks,
Lorbo