I have two workbooks. One is demand and one is supply, both vary in length
from day to day. I want to append the supply data to the end of the demand
data in a summary sheet for matching columns. Nonmatching columns have their
own independent column.

Obviously without cutting and pasting every day. Length of supply data is
about 3000 lines, length of demand data is about 10000 lines. Each has 3 to 4
correlating columns and 5 to 7 non correlating columns.

Example

Demand
PN Due Date Qty Parent Assy
123 Nov 6 2008 3 Car
764 Oct 10 2008 6 Plane
257 Spet 5 2008 1 Bus

Supply

PN Due Date Qty Purchase Order
764 Oct 9 2008 4 JHY
146 Oct 27 2008 1 KlR


Desired Output

PN Due Date Qty Parent Assy Purchase Order
123 Nov 6 2008 3 Car
764 Oct 10 2008 6 Plane
257 Spet 5 2008 1 Bus
764 Oct 9 2008 2 4 JHY
146 Oct 27 2008 1 KlR

PN
--
Dennis P