I have two worksheets containing 6 columns of data. The data in the first
worksheets represents customer orders at a very detailed level. The second
worksheet shows shipments on those orders at a much less detailed level. The
columns in both worksheets contain data that when I paste one on top of the
other in a third excel worksheet provides meaningful analysis for management.
We'd like to elimate the cutting and pasting in order to make the tool more
userfriendly.

I tried to use pivot tables from multiple ranges and found that while they
work, the pivot table is much less meaninful when using that fuctionality.

Using a macro or visual basic, is there a way to combine the data in the two
worksheets in a third worksheet that can be summarized in a pivot table?