Hello all.

I have a worksheet with 70 columns of data. I need to look bac
through all columns in each row (I will need the formula in each cel
of the last row), find the first blank cell, and copy the data from th
cell in the same row but 2 columns before the blank cell.

eg. Cell T34 is blank, I want the value (text) from cell R34 copie
into cell CD 34.

I hope I've explained enough.

Thanks in advance..

--
Message posted from http://www.ExcelForum.com