hi, after a long time of searching I decided to post my question and ask for help.
I have a data like this from sales, and I should send it to invoice template for print. I want to create a macro
asking for invoice number to print. then send data to a template invoice on a sheet 2
<colgroup><col><col><col span="4"><col><col></colgroup><tbody>
</tbody>
on sheet 2 invoice template it should look like this
invoice number 13
14 A B C
15 0.0904 4 Oak2
16 0.1905 9 pine
Thanks in advance
ellilio
I have a data like this from sales, and I should send it to invoice template for print. I want to create a macro
asking for invoice number to print. then send data to a template invoice on a sheet 2
Inv# | Date | Desc | Qty | Length | Width | Thickness | CubicM | |||
13 | 10/24/2017 | Oak2 | 1 | 230 | 15 | 5 | 0.01725 | |||
13 | 10/24/2017 | Oak2 | 1 | 250 | 17 | 5 | 0.02125 | |||
13 | 10/24/2017 | Oak2 | 1 | 260 | 18 | 5 | 0.02340 | |||
13 | 10/24/2017 | Oak2 | 1 | 300 | 19 | 5 | 0.02850 | |||
13 | 10/24/2017 | Pine | 5 | 300 | 15 | 5 | 0.11250 | |||
13 | 10/24/2017 | Pine | 4 | 300 | 13 | 5 | 0.07800 | |||
14 | 10/27/2017 | Oak1 | 1 | 245 | 15 | 5 | 0.0184 | |||
14 | 10/27/2017 | Oak1 | 1 | 245 | 15 | 5 | 0.0184 | |||
14 | 10/27/2017 | Oak2 | 1 | 250 | 16 | 5 | 0.0200 | |||
14 | 10/27/2017 | Oak3 | 1 | 260 | 17 | 5 | 0.0221 | |||
14 | 10/27/2017 | Oak2 | 1 | 280 | 18 | 5 | 0.0252 | |||
14 | 10/27/2017 | Oak3 | 1 | 255 | 19 | 5 | 0.0242 | |||
14 | 10/27/2017 | Pine | 5 | 300 | 15 | 5 | 0.1125 |
<colgroup><col><col><col span="4"><col><col></colgroup><tbody>
</tbody>
on sheet 2 invoice template it should look like this
invoice number 13
14 A B C
15 0.0904 4 Oak2
16 0.1905 9 pine
Thanks in advance
ellilio