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?

--
Rick (MVP - Excel)


"Bobbo" wrote in message
...
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