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:
