bencookman
New Member
- Joined
- Mar 15, 2006
- Messages
- 21
Hello
I would like a macro that works through a long worksheet, set up as follows:
Column A: product code (3-digit code)
Column B: notes about product (free text - can span multiple rows due to character limits)
Column A is blank in the rows where the data in column B has spilled onto multiple rows.
I would like a macro that will loop the worksheet and and concatenate the contents of column B into a new column C, so that all the notes for a given product are shown in a single row. The icing on the cake would be to delete the now redundant blank rows between product codes.
I'm struggling with the "keep concatenating the rows in column B until you find a non-blank entry in column A" piece of it. All help appreciated.
I would like a macro that works through a long worksheet, set up as follows:
Column A: product code (3-digit code)
Column B: notes about product (free text - can span multiple rows due to character limits)
Column A is blank in the rows where the data in column B has spilled onto multiple rows.
I would like a macro that will loop the worksheet and and concatenate the contents of column B into a new column C, so that all the notes for a given product are shown in a single row. The icing on the cake would be to delete the now redundant blank rows between product codes.
I'm struggling with the "keep concatenating the rows in column B until you find a non-blank entry in column A" piece of it. All help appreciated.