LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Number of copies to print keep defaulting to 12 copies why? Boski Excel Worksheet Functions 1 October 8th 09 05:33 PM
print number of copies Sunny Excel Discussion (Misc queries) 1 August 29th 06 05:00 PM
Print number of copies Tarique Excel Discussion (Misc queries) 2 April 24th 06 07:45 PM
I need to print many copies of a document, how can I number them? bronxbobc Excel Discussion (Misc queries) 0 February 6th 06 09:28 PM
Print number of copies box EMoe[_82_] Excel Programming 5 December 8th 05 03:09 PM


All times are GMT +1. The time now is 03:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"