Hi

I have 2 worksheets, on the 1st is a list customers and on the 2nd is a list
of companies that the customers belong to.

I'd like to combine the lists into one so that the company appears at the
top and the customers underneath. If also possible I'd like to put a page
break in so one company appears on each printed page.

See example info below.

Sheet 1
Comp ID Address1 Address2 Address3 Post Code Company Amount Due
33560 PO Box 12 Bulwer Ave Berks BG1 2TY Towry £120
50560 PO Box 11 Sandy Lane Sussex J20 7YU Skipton £110

Sheet 2
Comp ID Address1 Address2 Address3 Post Code Name Amt Owed

33560 1 Tall Lane Lurgan Harts WR1 2BH Mr J Smith £60
33560 41 Irish Rd Mile Cross Cambs IR4 8UJ Mr I Cole £60
50560 1 Brae Ave Drumbo Pinner DM4 1KL Mr K Loch £50
50560 7 Allyn Rd Camberly Surrey GH7 8JL Mr H Jones £60

Thanks in advance

Andy