Hi -

I am working on a macro that I need to concatenate multiple cells (I'm using
the =A1&"_"&B1 formula). My problem is that the range of cells I need to
merge is variable based on the data in a previous column. If cell A30 = X
then add cell D30 to a concantenated list that has already been started;
next if A31 = X then add cell D31 to the afore mentioned list, etc. etc. I
can get the macro to evaluate the criteria but can it add a cell (D30) to a
cell which already has an existing concatenated formula? ie. (=L2&" "&L3&"
"&L4&" "&L5 + a new cell)

Hope your not too confused. Thanks in advance for your help!