So I have several lines of data and I am creating a concatenation
statement. I enter the statement in row 1 and copy it down. The
formula that shows in the formula bar correctly updates the row numbers
as you go down but the data in the formula continues to be that of row
1. However, if, for any given row, I click into the formula bar and
hit enter the data updates to that of the row. i.e. row 5 then would
be correct. This would be fine to do except that there are 5000+
lines.

Any thoughts?


--
SOX101010
------------------------------------------------------------------------
SOX101010's Profile: http://www.excelforum.com/member.php...o&userid=30205
View this thread: http://www.excelforum.com/showthread...hreadid=498867