Hi all,
I have a worksheet which holds the results of two database queries. I want
to combine the regions programmatically saving the results to a new sheet. I
cannot create a single query to retrieve the combined data.
The initial worksheet looks similar to the following illustration:
Sheet 1:
Region 1:
Header1a Header1b Header1c ... Header1(n)
Row1a Row1b Row1c ... Row1(n)
Row1a Row1b Row1c ... Row1(n)
.... ... ... ... ...
.... ... ... ... ...
Row(N)a Row(N)b Row(N)c ... Row(N)(n)
Region 2:
Header2a Header2b Header2c ... Header2(n)
Row1a Row1b Row1c ... Row1(n)
Row1a Row1b Row1c ... Row1(n)
.... ... ... ... ...
.... ... ... ... ...
Row(N)a Row(N)b Row(N)c ... Row(N)(n)
The regions are separated by one or more blank lines. I'm going to remove
the sorting, grouping, and subtotals being applied to each region. Finally,
I want to grab the data combining it onto a new sheet. The columns and
formatting will alight between the regions. I'm not sure how to pick up the
data.
Bookmarks