ed.ayers315
Board Regular
- Joined
- Dec 14, 2009
- Messages
- 166
Hello Forum goers,
I need help with building a macro to accomplish a complexed wish list.
Tried numerous other solutions and tried combining some but could not get the needed result.
I deleted rows from the worksheet so it would fit better and hopefully easier to follow; the far right explainations have the correct row numbers.
Excel 2007
<tbody>
</tbody>
I need help with building a macro to accomplish a complexed wish list.
Tried numerous other solutions and tried combining some but could not get the needed result.
I deleted rows from the worksheet so it would fit better and hopefully easier to follow; the far right explainations have the correct row numbers.
Excel 2007
B | C | D | E | F | G | H | I | J | K | |
---|---|---|---|---|---|---|---|---|---|---|
1 | ||||||||||
2 | Total Print Range is from B1:I210 | |||||||||
3 | ||||||||||
4 | I use a filter to hide rows that do not need to print | |||||||||
5 | ||||||||||
6 | I use a macro found on this forum to reset the page #s when filtered. | |||||||||
7 | ||||||||||
8 | This setion with a footer | |||||||||
9 | Should be on it's own page | |||||||||
10 | This section is from Rows 1-17 | |||||||||
11 | ||||||||||
12 | ||||||||||
13 | ||||||||||
14 | ||||||||||
15 | This section sould repeat lines 19 & 20 if more than one page. | |||||||||
16 | ||||||||||
17 | ||||||||||
18 | Is it possible to set up printing so these 3 row combinations stay together and not printed on different pages | |||||||||
19 | This section is from Rows 19-56 | |||||||||
20 | ||||||||||
21 | This section sould repeat lines 58 & 59 if more than one page. | |||||||||
22 | ||||||||||
23 | ||||||||||
24 | Is it possible to set up printing so these 3 row combinations stay together and not printed on different pages | |||||||||
25 | This section is from Rows 58-89 | |||||||||
26 | ||||||||||
27 | ||||||||||
28 | This section sould repeat lines 91 & 92 if more than one page. | |||||||||
29 | ||||||||||
30 | ||||||||||
31 | This section sould repeat lines 97 & 98 if more than one page. | |||||||||
32 | ||||||||||
33 | ||||||||||
34 | This section sould repeat lines 102 if more than one page. | |||||||||
35 | This section is from Rows 102-110 | |||||||||
36 | ||||||||||
37 | This section sould repeat lines 112-114 if more than one page. | |||||||||
38 | This section is from Rows 112-118 | |||||||||
39 | ||||||||||
40 | ||||||||||
41 | This section sould repeat lines 119-120 if more than one page. | |||||||||
42 | ||||||||||
43 | Is it possible to set up printing so these 2 row combinations stay together and not printed on different pages | |||||||||
44 | This section is from Rows 119-148 | |||||||||
45 | ||||||||||
46 | ||||||||||
47 | This section sould repeat lines 150-151 if more than one page. | |||||||||
48 | Is it possible to set up printing so these 2 row combinations stay together and not printed on different pages | |||||||||
49 | This section is from Rows 150-179 | |||||||||
50 | ||||||||||
51 | This section sould repeat lines 181-182 if more than one page. | |||||||||
52 | ||||||||||
53 | Is it possible to set up printing so these 2 row combinations stay together and not printed on different pages | |||||||||
54 | This section is from Rows 181-196 | |||||||||
55 | ||||||||||
56 | This section sould repeat lines 198-199 if more than one page. | |||||||||
57 | ||||||||||
58 | Is it possible to set up printing so that 1 row not printed on different pages | |||||||||
59 | This section is from Rows 198-208 | |||||||||
60 | ||||||||||
61 | Allways printed on the last page Row 210 | |||||||||
62 |
<tbody>
</tbody>
Sheet1
Last edited: