Variable that can reset while looping

This is a bit hard to explain, but I'm hoping those greater than me can make some sense out of this mess...

HOLDER IMPORT Working Copy.xls

I need to test for blanks in Column B (Addr). When there is a blank I need the data on that row from Column A (Name) to be concatonated to the end of the text in the row above Column J (Desc of Ops/Special Conds). I need this test with results to continue updating until there is not a blank in Column B. I have it working very inefficiently using nested IF statements within Excel, but only for 2 rows and that's not going to cut it.

I was wondering if I could get a variable (or a few variables) to 1) mark the last text in J where there was also text in B 2) collect all the text in A where there is no text in B 3) combine all of what was collected in A in order to the end of the last mark. And since I never know how many entries I will have I need all this testing and reseting to continue happening until there are no more rows with data.

Help?

Hi

try this

Please Login or Register  to view this content.

rylo