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

Looks like your calculation is set to Manual, hit F9 to check, then go
to Tools/Option/Calculation and select Automatic.

Regards
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=498867

That did it... sure is a nice bit of info to know.

Thanks!!


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