Spreadsheet: 748954d1632425383-copying-formatting-to-a-new-workbook-in-a-quick-way-format-example
Sheet: New

Order | Company Name | Branch | Code | Invoice Number | Doc Date | Value | Terms | Due Date | Days O/S | Not Due | Format
17 | Company9 | 134 | 516680 | 134/516680 | 2016-07-17 00:00:00 | 45829.68 | 30 | 2019-08-16 00:00:00
18 | Company7 | 172 | 151025 | 172/151025 | 2015-10-21 00:00:00 | 142627.37 | 30 | 2018-11-19 00:00:00
19 | Company9 | 157 | 592097 | 157/592097 | 2015-10-25 00:00:00 | 51707.15 | 30 | 2018-11-23 00:00:00
20 | Company2 | 139 | 665804 | 139/665804 | 2015-06-09 00:00:00 | 48722.24 | 30 | 2018-07-08 00:00:00
21 | Company9 | 116 | 514496 | 116/514496 | 2017-02-19 00:00:00 | 75702.95 | 30 | 2020-03-20 00:00:00
22 | Company6 | 110 | 274569 | 110/274569 | 2017-07-11 00:00:00 | 161289.32 | 30 | 2020-08-09 00:00:00
23 | Company5 | 160 | 661930 | 160/661930 | 2018-06-19 00:00:00 | 149689.67 | 30 | 2021-07-18 00:00:00
24 | Company6 | 168 | 412400 | 168/412400 | 2015-12-02 00:00:00 | 61212.74 | 30 | 2018-12-31 00:00:00
25 | Company3 | 129 | 124860 | 129/124860 | 2018-07-26 00:00:00 | 35796.78 | 30 | 2021-08-24 00:00:00
26 | Company3 | 166 | 384259 | 166/384259 | 2019-04-14 00:00:00 | 57636.12 | 30 | 2022-05-13 00:00:00
27 | Company10 | 161 | 374372 | 161/374372 | 2016-05-01 00:00:00 | 70316.29 | 30 | 2019-05-31 00:00:00
28 | Company5 | 101 | 678020 | 101/678020 | 2018-11-11 00:00:00 | 99438.8 | 30 | 2021-12-10 00:00:00
29 | Company9 | 121 | 571448 | 121/571448 | 2018-03-06 00:00:00 | 75273.22 | 30 | 2021-04-04 00:00:00
30 | Company7 | 138 | 203828 | 138/203828 | 2018-04-08 00:00:00 | 234987.57 | 30 | 2021-05-07 00:00:00
31 | Company8 | 158 | 651526 | 158/651526 | 2019-03-11 00:00:00 | 7880.5 | 30 | 2022-04-09 00:00:00
32 | Company10 | 170 | 224695 | 170/224695 | 2015-03-29 00:00:00 | 221781.98 | 30 | 2018-04-27 00:00:00
33 | Company6 | 120 | 488232 | 120/488232 | 2016-04-20 00:00:00 | 124722.33 | 30 | 2019-05-20 00:00:00
34 | Company1 | 175 | 294057 | 175/294057 | 2017-10-01 00:00:00 | 188791.61 | 30 | 2020-10-30 00:00:00
35 | Company2 | 155 | 342059 | 155/342059 | 2016-05-18 00:00:00 | 72360.53 | 30 | 2019-06-17 00:00:00
36 | Company3 | 145 | 379256 | 145/379256 | 2019-09-26 00:00:00 | 215142.26 | 30 | 2022-10-25 00:00:00
37 | Company4 | 106 | 321717 | 106/321717 | 2017-04-16 00:00:00 | 210624.7 | 30 | 2020-05-15 00:00:00
38 | Company5 | 156 | 121772 | 156/121772 | 2016-04-23 00:00:00 | 75019.5 | 30 | 2019-05-23 00:00:00
39 | Company1 | 175 | 415474 | 175/415474 | 2015-11-23 00:00:00 | 52984.1 | 30 | 2018-12-22 00:00:00
40 | Company8 | 112 | 141315 | 112/141315 | 2018-07-25 00:00:00 | 67573.29 | 30 | 2021-08-23 00:00:00
41 | Company7 | 148 | 353071 | 148/353071 | 2017-02-07 00:00:00 | 222950.87 | 30 | 2020-03-08 00:00:00
42 | Company3 | 121 | 380321 | 121/380321 | 2015-10-23 00:00:00 | 37057.65 | 30 | 2018-11-21 00:00:00
43 | Company4 | 104 | 301963 | 104/301963 | 2019-10-17 00:00:00 | 38498.37 | 30 | 2022-11-15 00:00:00
44 | Company9 | 158 | 550713 | 158/550713 | 2019-10-04 00:00:00 | 238111.52 | 30 | 2022-11-02 00:00:00
45 | Company5 | 107 | 678606 | 107/678606 | 2017-01-10 00:00:00 | 123687.45 | 30 | 2020-02-09 00:00:00
46 | Company8 | 138 | 123366 | 138/123366 | 2018-08-07 00:00:00 | 233996.72 | 30 | 2021-09-05 00:00:00
47 | Company10 | 116 | 600849 | 116/600849 | 2017-03-07 00:00:00 | 25364.7 | 30 | 2020-04-05 00:00:00
48 | Company3 | 127 | 125569 | 127/125569 | 2019-12-26 00:00:00 | 92340.21 | 30 | 2023-01-24 00:00:00
49 | Company1 | 154 | 269004 | 154/269004 | 2018-04-13 00:00:00 | 240004.99 | 30 | 2021-05-12 00:00:00
50 | Company4 | 101 | 162427 | 101/162427 | 2016-12-04 00:00:00 | 1869.96 | 30 | 2020-01-03 00:00:00
51 | Company3 | 124 | 398997 | 124/398997 | 2018-11-07 00:00:00 | 14828.2 | 30 | 2021-12-06 00:00:00
52 | Company6 | 105 | 233761 | 105/233761 | 2015-03-24 00:00:00 | 94150.11 | 30 | 2018-04-22 00:00:00
53 | Company5 | 113 | 143765 | 113/143765 | 2019-06-12 00:00:00 | 179464.35 | 30 | 2022-07-11 00:00:00
54 | Company8 | 165 | 524353 | 165/524353 | 2019-12-27 00:00:00 | 178826.96 | 30 | 2023-01-25 00:00:00
55 | Company6 | 149 | 478449 | 149/478449 | 2016-03-23 00:00:00 | 70078.17 | 30 | 2019-04-22 00:00:00
56 | Company3 | 126 | 650262 | 126/650262 | 2015-05-08 00:00:00 | 148407.5 | 30 | 2018-06-06 00:00:00
57 | Company7 | 175 | 555609 | 175/555609 | 2017-07-03 00:00:00 | 130832.87 | 30 | 2020-08-01 00:00:00
58 | Company2 | 175 | 555741 | 175/555741 | 2018-08-10 00:00:00 | 77575.83 | 30 | 2021-09-08 00:00:00
59 | Company7 | 115 | 373394 | 115/373394 | 2017-01-07 00:00:00 | 108248.57 | 30 | 2020-02-06 00:00:00
60 | Company1 | 169 | 695391 | 169/695391 | 2015-06-25 00:00:00 | 245168.24 | 30 | 2018-07-24 00:00:00
61 | Company9 | 174 | 504233 | 174/504233 | 2015-12-22 00:00:00 | 208409.6 | 30 | 2019-01-20 00:00:00
62 | Company2 | 112 | 483313 | 112/483313 | 2018-04-23 00:00:00 | 204117.5 | 30 | 2021-05-22 00:00:00
63 | Company1 | 137 | 677812 | 137/677812 | 2015-02-18 00:00:00 | 15095.91 | 30 | 2018-03-19 00:00:00
64 | Company8 | 112 | 388713 | 112/388713 | 2017-12-29 00:00:00 | 185677.81 | 30 | 2021-01-27 00:00:00
65 | Company2 | 149 | 328820 | 149/328820 | 2020-01-26 00:00:00 | 85859.93 | 30 | 2023-02-24 00:00:00
66 | Company5 | 174 | 422802 | 174/422802 | 2019-09-15 00:00:00 | 183649.85 | 30 | 2022-10-14 00:00:00
67 | Company8 | 110 | 122627 | 110/122627 | 2016-05-20 00:00:00 | 87807.84 | 30 | 2019-06-19 00:00:00
68 | Company4 | 108 | 104961 | 108/104961 | 2018-07-17 00:00:00 | 202578.8 | 30 | 2021-08-15 00:00:00
69 | Company2 | 161 | 499208 | 161/499208 | 2017-05-16 00:00:00 | 84870.41 | 30 | 2020-06-14 00:00:00
70 | Company8 | 168 | 636600 | 168/636600 | 2020-02-08 00:00:00 | 41405.42 | 30 | 2023-03-09 00:00:00
71 | Company2 | 118 | 576908 | 118/576908 | 2019-09-07 00:00:00 | 56640.48 | 30 | 2022-10-06 00:00:00
72 | Company1 | 121 | 632607 | 121/632607 | 2019-08-26 00:00:00 | 38908.92 | 30 | 2022-09-24 00:00:00
73 | Company6 | 140 | 199617 | 140/199617 | 2017-12-10 00:00:00 | 25056.33 | 30 | 2021-01-08 00:00:00
74 | Company5 | 134 | 328612 | 134/328612 | 2020-01-24 00:00:00 | 193822.69 | 30 | 2023-02-22 00:00:00
75 | Company5 | 150 | 473780 | 150/473780 | 2018-05-10 00:00:00 | 95113.22 | 30 | 2021-06-08 00:00:00
76 | Company10 | 145 | 383775 | 145/383775 | 2019-10-29 00:00:00 | 52246.36 | 30 | 2022-11-27 00:00:00
77 | Company1 | 108 | 315241 | 108/315241 | 2018-07-10 00:00:00 | 98655.2 | 30 | 2021-08-08 00:00:00
78 | Company7 | 103 | 258031 | 103/258031 | 2016-10-19 00:00:00 | 32091 | 30 | 2019-11-18 00:00:00
79 | Company9 | 175 | 459719 | 175/459719 | 2019-02-26 00:00:00 | 247865.32 | 30 | 2022-03-27 00:00:00
80 | Company9 | 142 | 645814 | 142/645814 | 2015-07-03 00:00:00 | 197490.86 | 30 | 2018-08-01 00:00:00
81 | Company2 | 148 | 321401 | 148/321401 | 2019-12-18 00:00:00 | 17619.61 | 30 | 2023-01-16 00:00:00
82 | Company2 | 130 | 575300 | 130/575300 | 2016-05-23 00:00:00 | 13263.21 | 30 | 2019-06-22 00:00:00
83 | Company4 | 159 | 563055 | 159/563055 | 2015-10-27 00:00:00 | 14552.71 | 30 | 2018-11-25 00:00:00
84 | Company9 | 139 | 166514 | 139/166514 | 2015-05-25 00:00:00 | 48647.1 | 30 | 2018-06-23 00:00:00
85 | Company9 | 136 | 687344 | 136/687344 | 2019-03-20 00:00:00 | 247046.59 | 30 | 2022-04-18 00:00:00
86 | Company6 | 168 | 314281 | 168/314281 | 2016-10-18 00:00:00 | 133842.87 | 30 | 2019-11-17 00:00:00
87 | Company3 | 130 | 503235 | 130/503235 | 2017-08-27 00:00:00 | 247568.79 | 30 | 2020-09-25 00:00:00
88 | Company9 | 145 | 496903 | 145/496903 | 2015-01-30 00:00:00 | 221397.2 | 30 | 2018-02-28 00:00:00
89 | Company7 | 114 | 514463 | 114/514463 | 2018-11-23 00:00:00 | 239009.27 | 30 | 2021-12-22 00:00:00
90 | Company10 | 156 | 482469 | 156/482469 | 2016-09-25 00:00:00 | 184350.51 | 30 | 2019-10-25 00:00:00
91 | Company2 | 161 | 196653 | 161/196653 | 2016-06-25 00:00:00 | 221740.81 | 30 | 2019-07-25 00:00:00
92 | Company7 | 143 | 410759 | 143/410759 | 2019-11-28 00:00:00 | 50393.44 | 30 | 2022-12-27 00:00:00
93 | Company4 | 128 | 496406 | 128/496406 | 2015-01-22 00:00:00 | 115600.84 | 30 | 2018-02-20 00:00:00
94 | Company4 | 128 | 495116 | 128/495116 | 2016-09-06 00:00:00 | 93405.67 | 30 | 2019-10-06 00:00:00
95 | Company6 | 154 | 654341 | 154/654341 | 2017-07-11 00:00:00 | 164288.14 | 30 | 2020-08-09 00:00:00
96 | Company9 | 138 | 510786 | 138/510786 | 2015-06-16 00:00:00 | 124210.7 | 30 | 2018-07-15 00:00:00
97 | Company7 | 168 | 626582 | 168/626582 | 2018-07-23 00:00:00 | 39598.98 | 30 | 2021-08-21 00:00:00
98 | Company3 | 129 | 576350 | 129/576350 | 2018-03-31 00:00:00 | 249790.72 | 30 | 2021-04-29 00:00:00
99 | Company9 | 108 | 309916 | 108/309916 | 2018-06-27 00:00:00 | 31497.38 | 30 | 2021-07-26 00:00:00
100 | Company8 | 122 | 292435 | 122/292435 | 2016-10-26 00:00:00 | 64049.97 | 30 | 2019-11-25 00:00:00
101 | Company7 | 163 | 254674 | 163/254674 | 2016-12-15 00:00:00 | 29014.51 | 30 | 2020-01-14 00:00:00
102 | Company3 | 120 | 673228 | 120/673228 | 2017-10-28 00:00:00 | 180796.16 | 45 | 2020-12-11 00:00:00
103 | Company10 | 132 | 403705 | 132/403705 | 2016-08-19 00:00:00 | 8318.8 | 45 | 2019-10-03 00:00:00
104 | Company10 | 152 | 664665 | 152/664665 | 2017-10-12 00:00:00 | 74508.81 | 45 | 2020-11-25 00:00:00
105 | Company7 | 142 | 316353 | 142/316353 | 2016-12-11 00:00:00 | 119043.97 | 45 | 2020-01-25 00:00:00
106 | Company8 | 108 | 251523 | 108/251523 | 2017-01-11 00:00:00 | 242792.45 | 45 | 2020-02-25 00:00:00
107 | Company10 | 150 | 637072 | 150/637072 | 2015-02-07 00:00:00 | 59929.6 | 45 | 2018-03-23 00:00:00
108 | Company1 | 120 | 668531 | 120/668531 | 2018-07-21 00:00:00 | 194399.58 | 45 | 2021-09-03 00:00:00
109 | Company2 | 139 | 567263 | 139/567263 | 2017-10-04 00:00:00 | 103903.52 | 45 | 2020-11-17 00:00:00
110 | Company9 | 118 | 490435 | 118/490435 | 2015-08-22 00:00:00 | 207287.6 | 45 | 2018-10-05 00:00:00
111 | Company4 | 115 | 306509 | 115/306509 | 2018-01-08 00:00:00 | 248581.19 | 45 | 2021-02-21 00:00:00
112 | Company4 | 148 | 338325 | 148/338325 | 2019-02-18 00:00:00 | 120702.58 | 45 | 2022-04-03 00:00:00
113 | Company8 | 110 | 436483 | 110/436483 | 2019-03-20 00:00:00 | 56331.61 | 45 | 2022-05-03 00:00:00
114 | Company2 | 138 | 508809 | 138/508809 | 2016-12-28 00:00:00 | 27723.15 | 45 | 2020-02-11 00:00:00
115 | Company2 | 132 | 530952 | 132/530952 | 2018-02-20 00:00:00 | 79483.7 | 45 | 2021-04-05 00:00:00
116 | Company1 | 148 | 449635 | 148/449635 | 2019-09-16 00:00:00 | 10966.91 | 45 | 2022-10-30 00:00:00
117 | Company8 | 104 | 265382 | 104/265382 | 2016-06-27 00:00:00 | 121834.96 | 45 | 2019-08-11 00:00:00
118 | Company1 | 167 | 591412 | 167/591412 | 2016-05-16 00:00:00 | 175400.41 | 45 | 2019-06-30 00:00:00
119 | Company2 | 103 | 668998 | 103/668998 | 2019-03-08 00:00:00 | 214564.2 | 45 | 2022-04-21 00:00:00
120 | Company5 | 107 | 340615 | 107/340615 | 2020-01-30 00:00:00 | 169099.43 | 45 | 2023-03-15 00:00:00
121 | Company2 | 133 | 385471 | 133/385471 | 2016-04-06 00:00:00 | 97639.93 | 45 | 2019-05-21 00:00:00