Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi to the experts/developers
I have developed a routine to print slips, six to a (portrait) page (three across and two down) It works well. However when the pages are guillotined the slips need sorting. When dealing wih a hundred or more the task is pretty onerous. I wondered whether any one has had to deal with this problem before? I would like to place them on the page so that when guillotined the slips fall on top of each other in an easier-to-sort manner. A partial extract from the routine: Sub Numbers() Dim myNumber As Integer Dim Firstnumber As Integer Dim LastNumber As Integer Firstnumber = 1 LastNumber = 36 Sheets("Numbers").Select Cells.Clear For myNumber = Firstnumber To LastNumber Cells(1 + (Abs(myNumber / 2 = myNumber \ 2)) * 10, 1 + (myNumber - Firstnumber - _ (Abs(myNumber / 2 = myNumber \ 2))) * 2) = myNumber Next myNumber End Sub This then lays them out as follows: 1 3 5 7 9 11 13 15 17 2 4 6 8 10 12 14 16 18 What I am looking for is something like: 1 7 13 2 8 14 3 9 15 19 25 31 20 26 32 21 27 33 Continuing to the right of the above 4 10 16 5 11 17 6 12 18 22 28 34 23 29 35 24 30 36 Etc The maximum will be about 180 slips so they can go across the top but wouldn 't matter going down either. Has anybody developed the maths to position the slips as above to facilitate their guillotining? Thanks Peter Bircher SA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Routing slips in Excel 2007 | Excel Discussion (Misc queries) | |||
pay slips | Excel Worksheet Functions | |||
Packing Slips | Excel Discussion (Misc queries) | |||
Routing Slips | Excel Discussion (Misc queries) | |||
Routing Slips | Excel Discussion (Misc queries) |