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

Order | Company Name | Branch | Code | Invoice Number | Doc Date | Value | Terms | Due Date | Days O/S | Not Due | Format
1 | Company2 | 174 | 526934 | 174/526934 | 2018-08-24 00:00:00 | 41253.4 | 30 | 2021-09-22 00:00:00 |  |  | Paying
2 | Company6 | 125 | 173544 | 125/173544 | 2015-01-31 00:00:00 | 215847.7 | 30 | 2018-03-01 00:00:00 |  |  | Query
3 | Company7 | 119 | 496678 | 119/496678 | 2016-02-09 00:00:00 | 14924.16 | 30 | 2019-03-10 00:00:00 |  |  | QS
4 | Company9 | 147 | 248293 | 147/248293 | 2017-10-05 00:00:00 | 24729.1 | 30 | 2020-11-03 00:00:00 |  |  | 3rd Party
5 | Company5 | 154 | 273758 | 154/273758 | 2015-07-28 00:00:00 | 6646.69 | 30 | 2018-08-26 00:00:00 |  |  | QS
6 | Company4 | 112 | 389705 | 112/389705 | 2015-07-14 00:00:00 | 109967.83 | 30 | 2018-08-12 00:00:00 |  |  | QS
7 | Company6 | 124 | 461945 | 124/461945 | 2017-05-29 00:00:00 | 143909.28 | 30 | 2020-06-27 00:00:00 |  |  | QS
8 | Company10 | 169 | 546921 | 169/546921 | 2018-08-11 00:00:00 | 24088.16 | 30 | 2021-09-09 00:00:00 |  |  | QS
9 | Company3 | 175 | 662326 | 175/662326 | 2017-07-21 00:00:00 | 197904.47 | 30 | 2020-08-19 00:00:00 |  |  | QS
10 | Company9 | 113 | 259741 | 113/259741 | 2015-12-09 00:00:00 | 8824.6 | 30 | 2019-01-07 00:00:00 |  |  | QS
11 | Company8 | 121 | 196243 | 121/196243 | 2016-08-02 00:00:00 | 93034.8 | 30 | 2019-09-01 00:00:00 |  |  | 3rd Party
12 | Company9 | 109 | 279199 | 109/279199 | 2016-07-12 00:00:00 | 158150.39 | 30 | 2019-08-11 00:00:00 |  |  | Paying
13 | Company3 | 111 | 643860 | 111/643860 | 2019-12-03 00:00:00 | 55512.72 | 30 | 2023-01-01 00:00:00 |  |  | Paying
14 | Company2 | 148 | 217503 | 148/217503 | 2019-03-17 00:00:00 | 97159.48 | 30 | 2022-04-15 00:00:00 |  |  | QS
15 | Company3 | 140 | 328631 | 140/328631 | 2017-02-27 00:00:00 | 129312.76 | 30 | 2020-03-28 00:00:00 |  |  | QS
16 | Company6 | 128 | 278393 | 128/278393 | 2017-10-10 00:00:00 | 192171.23 | 30 | 2020-11-08 00:00:00 |  |  | QS
17 | Company9 | 134 | 516680 | 134/516680 | 2016-07-17 00:00:00 | 45829.68 | 30 | 2019-08-16 00:00:00 |  |  | Paying
18 | Company7 | 172 | 151025 | 172/151025 | 2015-10-21 00:00:00 | 142627.37 | 30 | 2018-11-19 00:00:00 |  |  | Query
19 | Company9 | 157 | 592097 | 157/592097 | 2015-10-25 00:00:00 | 51707.15 | 30 | 2018-11-23 00:00:00 |  |  | Query
20 | Company2 | 139 | 665804 | 139/665804 | 2015-06-09 00:00:00 | 48722.24 | 30 | 2018-07-08 00:00:00 |  |  | Query
21 | Company9 | 116 | 514496 | 116/514496 | 2017-02-19 00:00:00 | 75702.95 | 30 | 2020-03-20 00:00:00 |  |  | Paying
22 | Company6 | 110 | 274569 | 110/274569 | 2017-07-11 00:00:00 | 161289.32 | 30 | 2020-08-09 00:00:00 |  |  | Paying
23 | Company5 | 160 | 661930 | 160/661930 | 2018-06-19 00:00:00 | 149689.67 | 30 | 2021-07-18 00:00:00 |  |  | Paying
24 | Company6 | 168 | 412400 | 168/412400 | 2015-12-02 00:00:00 | 61212.74 | 30 | 2018-12-31 00:00:00 |  |  | Paying
25 | Company3 | 129 | 124860 | 129/124860 | 2018-07-26 00:00:00 | 35796.78 | 30 | 2021-08-24 00:00:00 |  |  | Paying
26 | Company3 | 166 | 384259 | 166/384259 | 2019-04-14 00:00:00 | 57636.12 | 30 | 2022-05-13 00:00:00 |  |  | Paying
27 | Company10 | 161 | 374372 | 161/374372 | 2016-05-01 00:00:00 | 70316.29 | 30 | 2019-05-31 00:00:00 |  |  | Paying
28 | Company5 | 101 | 678020 | 101/678020 | 2018-11-11 00:00:00 | 99438.8 | 30 | 2021-12-10 00:00:00 |  |  | Paying
29 | Company9 | 121 | 571448 | 121/571448 | 2018-03-06 00:00:00 | 75273.22 | 30 | 2021-04-04 00:00:00 |  |  | Paying
30 | Company7 | 138 | 203828 | 138/203828 | 2018-04-08 00:00:00 | 234987.57 | 30 | 2021-05-07 00:00:00 |  |  | Paying
31 | Company8 | 158 | 651526 | 158/651526 | 2019-03-11 00:00:00 | 7880.5 | 30 | 2022-04-09 00:00:00 |  |  | Paying
32 | Company10 | 170 | 224695 | 170/224695 | 2015-03-29 00:00:00 | 221781.98 | 30 | 2018-04-27 00:00:00 |  |  | Paying
33 | Company6 | 120 | 488232 | 120/488232 | 2016-04-20 00:00:00 | 124722.33 | 30 | 2019-05-20 00:00:00 |  |  | Paying
34 | Company1 | 175 | 294057 | 175/294057 | 2017-10-01 00:00:00 | 188791.61 | 30 | 2020-10-30 00:00:00 |  |  | Paying
35 | Company2 | 155 | 342059 | 155/342059 | 2016-05-18 00:00:00 | 72360.53 | 30 | 2019-06-17 00:00:00 |  |  | Paying
36 | Company3 | 145 | 379256 | 145/379256 | 2019-09-26 00:00:00 | 215142.26 | 30 | 2022-10-25 00:00:00 |  |  | Paying
37 | Company4 | 106 | 321717 | 106/321717 | 2017-04-16 00:00:00 | 210624.7 | 30 | 2020-05-15 00:00:00 |  |  | Paying
38 | Company5 | 156 | 121772 | 156/121772 | 2016-04-23 00:00:00 | 75019.5 | 30 | 2019-05-23 00:00:00 |  |  | Paying
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