Hi,
I am trying to write code for a loop which does the following:
1.Change the value of cell A1 (to 1,2,3,4 etc. as it goes through the loop these numbers are in a range called List_numbers)
2. Save as the print_area to PDF in black and white
3. Save as to print_area to PDF in Colour
4. Repeat steps 2 and 3 until the end of List_numbers
The single cell which changes has 10 VLOOKUPs which depend on it so that each print out will be a different form for my overpaid plebians to complete when we do stocktake.
Any help would be greatly appreciated!
Bookmarks