Variable number of copies to print
 

In a xls 2007 workbook I set up a sheet (1) to record working machine per
days of month.
In (1) there is a cell retrieving the machine name with a vLookup function
pointing to another sheet (2). Here (2) is a cell with the number of copies
to be printed according to the machine.
So for instance in sheet (2) there is
m1 2 copies to be printed
m2 4 copies
m3 1 copy
....

I would like to print the numebr of copies of sheet (1) as specified in
sheet (2) and loop through the machines, so to print all the copies of all
the machines, that is

m1 2 +
m2 4 +
m3 1

Many thanks for help
--
Mich@el