bobbieatendido
New Member
- Joined
- Jul 13, 2016
- Messages
- 21
- Office Version
- 365
- Platform
- Windows
Hi,
Is there a way to automatically sort 2 database's by date and add space in between dates that are different?
In office 1 there is no date 11/05/23 and 11/16/23, so it will add a row to accommodate the date from office 2.
Same with office 2, since there is only 11/08/23, it will add a row so 11/10/23 in office 1 and 2 will be in one row.
Thank you
Is there a way to automatically sort 2 database's by date and add space in between dates that are different?
Book1.xlsx | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Office 1 | ||||||
2 | Date | PO# | JO# | FROM-TO | PRICE | ||
3 | 10/30/23 | 235545 | 10001 | HMD-TOI | 34,234 | ||
4 | 11/04/23 | 234456 | 10023 | FSK-IFM | 23,423 | ||
5 | 11/08/23 | 234543 | 10033 | KFM-FKS | 232 | ||
6 | 11/08/23 | 234325 | 10034 | DIC-KKO | 2,456 | ||
7 | 11/10/23 | 235524 | 10056 | SDK-OSD | 6,545 | ||
8 | 11/10/23 | 346324 | 10006 | OSD-SDK | 456 | ||
9 | 11/11/23 | 356784 | 10045 | DAN-CEW | 5,434 | ||
10 | 11/15/23 | 378940 | 10046 | MNL-KLW | 6,645 | ||
11 | 11/17/23 | 398467 | 10076 | PHP-USD | 4,564 | ||
12 | 11/20/23 | 255545 | 10044 | JDL-JKD | 7,889 | ||
Sheet1 |
Book1.xlsx | |||||||
---|---|---|---|---|---|---|---|
G | H | I | J | K | |||
1 | Office 2 | ||||||
2 | Date | PO# | JO# | FROM-TO | PRICE | ||
3 | 10/30/23 | 234456 | 10056 | SDK-OSD | 5,434 | ||
4 | 11/04/23 | 234543 | 10006 | OSD-SDK | 6,645 | ||
5 | 11/05/23 | 234325 | 10045 | DAN-CEW | 4,564 | ||
6 | 11/08/23 | 235524 | 10025 | SDK-OSD | 4,678 | ||
7 | 11/10/23 | 235459 | 10019 | OSD-SDK | 4,243 | ||
8 | 11/10/23 | 235757 | 10014 | SDK-OSD | 3,808 | ||
9 | 11/11/23 | 236056 | 10008 | OSD-SDK | 3,373 | ||
10 | 11/16/23 | 236354 | 10003 | FSK-IFM | 2,938 | ||
11 | 11/17/23 | 236653 | 10025 | KFM-FKS | 2,503 | ||
12 | 11/20/23 | 236952 | 10019 | PHP-USD | 2,068 | ||
Sheet1 |
Book1.xlsx | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | |||
14 | OFFICE 1&2 | ||||||||||||
15 | Date | PO# | JO# | FROM-TO | PRICE | Date | PO# | JO# | FROM-TO | PRICE | |||
16 | 10/30/23 | 235545 | 10001 | HMD-TOI | 34,234 | 10/30/23 | 234456 | 10056 | SDK-OSD | 5,434 | |||
17 | 11/04/23 | 234456 | 10023 | FSK-IFM | 23,423 | 11/04/23 | 234543 | 10006 | OSD-SDK | 6,645 | |||
18 | 11/05/23 | 234325 | 10045 | DAN-CEW | 4,564 | ||||||||
19 | 11/08/23 | 234543 | 10033 | KFM-FKS | 232 | 11/08/23 | 235524 | 10025 | SDK-OSD | 4,678 | |||
20 | 11/08/23 | 234325 | 10034 | DIC-KKO | 2,456 | ||||||||
21 | 11/10/23 | 235524 | 10056 | SDK-OSD | 6,545 | 11/10/23 | 235459 | 10019 | OSD-SDK | 4,243 | |||
22 | 11/10/23 | 346324 | 10006 | OSD-SDK | 456 | 11/10/23 | 235757 | 10014 | SDK-OSD | 3,808 | |||
23 | 11/11/23 | 356784 | 10045 | DAN-CEW | 5,434 | 11/11/23 | 236056 | 10008 | OSD-SDK | 3,373 | |||
24 | 11/15/23 | 378940 | 10046 | MNL-KLW | 6,645 | ||||||||
25 | 11/16/23 | 236354 | 10003 | FSK-IFM | 2,938 | ||||||||
26 | 11/17/23 | 398467 | 10076 | PHP-USD | 4,564 | 11/17/23 | 236653 | 10025 | KFM-FKS | 2,503 | |||
27 | 11/20/23 | 255545 | 10044 | JDL-JKD | 7,889 | 11/20/23 | 236952 | 10019 | PHP-USD | 2,068 | |||
Sheet1 |
In office 1 there is no date 11/05/23 and 11/16/23, so it will add a row to accommodate the date from office 2.
Same with office 2, since there is only 11/08/23, it will add a row so 11/10/23 in office 1 and 2 will be in one row.
Thank you