I suggest you repost the message to the Programming newsgroup - I am still

learning VBA. Shorten the message to something along the lines of:

I have an Excel worksheet with a packing list on sheet1

ITEM NO. QTY. PART NO.

1 5 Oven Base

2 36 Default

3 29 Oven Internal Wall

etc

I need a macro with these specs

For each item

a) copy the Part No data (column C) to column B on Sheet2. This is to be

done N times where N = value in column B of sheet1

(e.g. 5 times for first item filling B1, B2, B3, B4 and B5 of Sheet2 with

Oven Base)

b) print Sheet2

c) delete data on Sheet2 leaving formatting

next item in list.

I have looked at using Words mail merge but this isn,'t what i'm really
after
--
----------------------------
Couray Sheetmetal
9 Apsley Plc.
Seaford
Melbourne.
Australia.
PH 03 97861609

---------------------------