KlayontKress
Board Regular
- Joined
- Jan 20, 2016
- Messages
- 67
- Office Version
- 2016
- Platform
- Windows
To all,
I need to define a print are that will show on every page but I'm having difficulty because it's not just a row of column I need, it's specific cells.
The first page of this quote to a customer ranges from cells A1:J43. I need to repeat the data in Columns A:C (Print titles takes care of this) but also the data in Cells D1:H15. I know of no way to get this additional bit of data to carry over on ever sheet. I tried defining specific cells on row to repeat but that didn't work (life can't be that simple).
Does anyone know how to do this? I basically need a vertically Inverted L shaped print area to print on every page.
Data is below. Cells D16:H43 need to be dynamic and change with the data as it goes to the right across multiple columns (In this particular quote, the data extends to column CE but can go much further.
<tbody>
</tbody>
I need to define a print are that will show on every page but I'm having difficulty because it's not just a row of column I need, it's specific cells.
The first page of this quote to a customer ranges from cells A1:J43. I need to repeat the data in Columns A:C (Print titles takes care of this) but also the data in Cells D1:H15. I know of no way to get this additional bit of data to carry over on ever sheet. I tried defining specific cells on row to repeat but that didn't work (life can't be that simple).
Does anyone know how to do this? I basically need a vertically Inverted L shaped print area to print on every page.
Data is below. Cells D16:H43 need to be dynamic and change with the data as it goes to the right across multiple columns (In this particular quote, the data extends to column CE but can go much further.
A | B | C | D | E | F | G | H | I | J | |
1 | Logo here | |||||||||
2 | ||||||||||
3 | To: | Date: | 01/15/18 | |||||||
4 | ||||||||||
5 | Job: | Plan: | ||||||||
6 | ||||||||||
7 | This quotation includes the following: | |||||||||
8 | ||||||||||
9 | 1) ******* Cabinets and Bathroom Vanities per layouts provided by Enter Company Name Here. | |||||||||
10 | 2) NO applicable taxes. | |||||||||
11 | 3) Delivery and jobsite distribution. | |||||||||
12 | 4) Shipment of all lines and styles requires twenty (20) working days from date of order. | |||||||||
13 | ||||||||||
14 | ||||||||||
15 | ||||||||||
16 | Group | Style | STANDARD ******* | OPTION 194 120 REAR STAIRCASE | OPT 194 760 120 REAR STAIRCASE W CHEFS ******* | OPT 501 SOLARIUM ******* | OPT 501 194 120 SOLARIUM ******* W REAR STAIRCASE | OPT 529 NAPLES SUNROOM | OPT 529 194 120 NAPLES SUNROOM W REAR STAIRCASE | |
17 | ||||||||||
18 | Base | Standard | $$$$$ | $$$$$ | $$$$$ | $$$$$ | $$$$$ | $$$$$ | $$$$$ | |
19 | $$$$$ | $$$$$ | $$$$$ | $$$$$ | $$$$$ | $$$$$ | $$$$$ | |||
20 | Level 1 | Level 1 | $$$$$ | $$$$$ | $$$$$ | $$$$$ | $$$$$ | $$$$$ | $$$$$ | |
21 | $$$$$ | $$$$$ | $$$$$ | $$$$$ | $$$$$ | $$$$$ | $$$$$ | |||
22 | Level 2 | Level 2 | $$$$$ | $$$$$ | $$$$$ | $$$$$ | $$$$$ | $$$$$ | $$$$$ | |
23 | $$$$$ | $$$$$ | $$$$$ | $$$$$ | $$$$$ | $$$$$ | $$$$$ | |||
24 | Level 3 | Level 3 | $$$$$ | $$$$$ | $$$$$ | $$$$$ | $$$$$ | $$$$$ | $$$$$ | |
25 | $$$$$ | $$$$$ | $$$$$ | $$$$$ | $$$$$ | $$$$$ | $$$$$ | |||
26 | Level 4 | Level 4 | $$$$$ | $$$$$ | $$$$$ | $$$$$ | $$$$$ | $$$$$ | $$$$$ | |
27 | ||||||||||
28 | ||||||||||
29 | Add LEVEL 1 HARDWARE | $$$$ | $$$$ | $$$$ | $$$$ | $$$$ | $$$$ | $$$$ | ||
30 | Add LEVEL 2 HARDWARE | $$$$ | $$$$ | $$$$ | $$$$ | $$$$ | $$$$ | $$$$ | ||
31 | Add 42in Refrig Deco Door Package | |||||||||
32 | Add INSTALL NORTHEAST | $$$$$$ | $$$$$$ | $$$$$$ | $$$$$$ | $$$$$$ | $$$$$$ | $$$$$$ | ||
33 | Add SOUTHEAST INSTALL | $$$$$$ | $$$$$$ | $$$$$$ | $$$$$$ | $$$$$$ | $$$$$$ | $$$$$$ | ||
34 | Add Level 4 Base Cabs DSSK-TCCM8 | |||||||||
35 | ||||||||||
36 | ||||||||||
37 | ||||||||||
38 | Note: Prices include hardware | |||||||||
39 | ||||||||||
40 | NOTES: | |||||||||
41 | ||||||||||
42 | Sales Representative | |||||||||
43 | Name here |
<tbody>
</tbody>
Last edited: