Help with combining cells

B

Bobbo

I have a macro that pulls data from a web table. The colums used are A-H.
When importing some of the text in colum F is spread to mutipal rows. What I
would like to do is go down column D till something is foound. If found,
search the next row down to see if it is blank. If blank then add the
contents from that row in column F to the one above then delete the row. Then
on to the next row and till the end.

Thanks
Bob
 
R

Rick Rothstein

A couple of questions...

1. What if there are two or more blanks under the value found in Column D...
how is that to be handled?

2. For the blank cell in Column D... you want the contents of Column F in
that row "added" to the contents in Column F above it, right? What exactly
do you mean be "add" in this context... are you looking to concatenate the
values? If so, how... with a space, line feed, or something else between
them?
 
B

Bobbo

1. just roll it up with the other
2. Sorry for the confusion. All of the data will be text so I would like it
appended to the cell above. During the import for some reason a field is
being split into multiple rows.
 
R

Rick Rothstein

1. just roll it up with the other

Does "roll it up" mean concatenate? For example, if your first value with
twp blank cells following it is in Row 5 (meaning D5 has text in it D6 and
D7 are empty cells) and F5 contains the text "One" and F6 contains the text
"Two" and F7 contains the text "Three", do you want F5 to have the text
"OneTwoThree" in it after the worksheet is processed?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top