Variable number of copies to print

M

micky55

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top