M
Mike
Hi all,
I have ~2,000 worksheets with data all formatted identically.
Here's the problem:
Users manually divide continuous data (such as sentences or
paragraphs) across multiple rows in one column. These data can be
found in any column and divided amongst any number of rows.
So in the example below, there is one sentence divided among C1 and
C2.
There is another different sentence divided among C3 and C4.
It's not limited to this column - they could take up A1 to A6 with a
long, hyphenated string of categories-subcategories-sub-sub-
categories, etc, ad infinitum ad nauseum, if need be.
Furthermore, and this is important, each "record" is separated by
dotted-line borders. So with the example below, there would be a
dotted line border between rows 2 and 3 and then between 4 and 5 but
not between 3 and 4.
A B
C D E
1 Baseball Private Baseball is the best
Sport 50,000 subscribers.
2 [Blank] [Blank] sport
ever! [Blank] [Blank]
3 PBS Public Public TV deserves
Entertainment 1,500,000 viewers.
4 [Blank] [Blank] more money.
[Blank] [Blank]
5
6
7
So I've already made macros where I can select C1 and C2 in one mouse
move, then select C3 and C4 in the next move, use some shortcuts and
it will merge and concatenate the cells appropriately into one cell.
Does any one know of a way to search iteratively for the border, and
to then select/activate cells between the border as separate
selections? I have code that will mark and treat them as separate
sections (so they don't all concatenate together), I just cannot for
my life figure out how to search for different sizes of rows based on
the border.
I have ~2,000 worksheets with data all formatted identically.
Here's the problem:
Users manually divide continuous data (such as sentences or
paragraphs) across multiple rows in one column. These data can be
found in any column and divided amongst any number of rows.
So in the example below, there is one sentence divided among C1 and
C2.
There is another different sentence divided among C3 and C4.
It's not limited to this column - they could take up A1 to A6 with a
long, hyphenated string of categories-subcategories-sub-sub-
categories, etc, ad infinitum ad nauseum, if need be.
Furthermore, and this is important, each "record" is separated by
dotted-line borders. So with the example below, there would be a
dotted line border between rows 2 and 3 and then between 4 and 5 but
not between 3 and 4.
A B
C D E
1 Baseball Private Baseball is the best
Sport 50,000 subscribers.
2 [Blank] [Blank] sport
ever! [Blank] [Blank]
3 PBS Public Public TV deserves
Entertainment 1,500,000 viewers.
4 [Blank] [Blank] more money.
[Blank] [Blank]
5
6
7
So I've already made macros where I can select C1 and C2 in one mouse
move, then select C3 and C4 in the next move, use some shortcuts and
it will merge and concatenate the cells appropriately into one cell.
Does any one know of a way to search iteratively for the border, and
to then select/activate cells between the border as separate
selections? I have code that will mark and treat them as separate
sections (so they don't all concatenate together), I just cannot for
my life figure out how to search for different sizes of rows based on
the border.