I have a workbook where I have a list of items in one column on one worksheet with a thickness, width, length and weight of that item. Not all the listed items are available for a given application so there might me a line followed by several blanks followed by 5 lines and so one. This always varies. I want to transfer all the listed items along with their descriptions to another worksheet in the workbook but I want each line filled consecutively on that sheet and I want to concatenate the description and put the weight in a seperate cell.
In short, I want to loop thru the entire first sheet, extracting data and creating entries on the second sheet.
I am sure this is just as clear as mud! My descriptive abilities leave something to be desired. So I will try to attach an example.
Hope someone can help. I'm pretty sure this is very simple but I am still struggling with VBA code.