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

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

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.


"Rick Rothstein" wrote:

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

.

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?

--
Rick (MVP - Excel)


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


"Rick Rothstein" wrote:

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

.