madkinson
Board Regular
- Joined
- Dec 17, 2004
- Messages
- 113
- Office Version
- 365
- Platform
- Windows
I have a template file that is used to load data into a 3rd party application.
I also have another file created in a 3rd application.
I want to merge them so I will end up with something like this.
For example, cell A2 in example 2 should end up in cell F2 in example 1. Any assistance is greatly appreciated. thanks!
White_Eagle_Rail_Car_Data (4).xlsx | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
E | F | G | H | I | J | K | L | M | N | O | |||
1 | Location | Date | Train # | Ref # | Position | Vehicle ID | Gross | Net | Qty | Load Status | In/Out Status | ||
2 | 109 | 1 | 0 | 0 | E | I | |||||||
3 | 109 | 1 | 0 | 0 | E | I | |||||||
4 | 109 | 1 | 0 | 0 | E | I | |||||||
5 | 109 | 1 | 0 | 0 | E | I | |||||||
6 | 109 | 1 | 0 | 0 | E | I | |||||||
Dataset 1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
K2:K6 | K2 | =M2*2000 |
I also have another file created in a 3rd application.
White_Eagle_Rail_Car_Data (4).xlsx | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Date | Ref # | Vehicle ID | ||
2 | 11/05/23 | 1 | PMRX10303 | ||
3 | 11/05/23 | 2 | PMRX10291 | ||
4 | 11/05/23 | 3 | PMRX10263 | ||
5 | 11/05/23 | 4 | PMRX10255 | ||
6 | 11/05/23 | 5 | PMRX10297 | ||
Dataset 1 |
I want to merge them so I will end up with something like this.
White_Eagle_Rail_Car_Data (4).xlsx | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
E | F | G | H | I | J | K | L | M | N | O | |||
1 | Location | Date | Train # | Ref # | Position | Vehicle ID | Gross | Net | Qty | Load Status | In/Out Status | ||
2 | 109 | 11/5/2023 | 1 | 1 | 1 | PMRX10303 | 236000 | 0 | 118.00 | E | I | ||
3 | 109 | 11/5/2023 | 1 | 2 | 2 | PMRX10291 | 236000 | 0 | 118.00 | E | I | ||
4 | 109 | 11/5/2023 | 1 | 3 | 3 | PMRX10263 | 236000 | 0 | 118.00 | E | I | ||
5 | 109 | 11/5/2023 | 1 | 4 | 4 | PMRX10255 | 236000 | 0 | 118.00 | E | I | ||
6 | 109 | 11/5/2023 | 1 | 5 | 5 | PMRX10297 | 236000 | 0 | 118.00 | E | I | ||
7 | |||||||||||||
8 | Calculated | ||||||||||||
9 | Merged | ||||||||||||
Dataset 1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
I2:I6 | I2 | =H2 |
K2:K6 | K2 | =M2*2000 |
For example, cell A2 in example 2 should end up in cell F2 in example 1. Any assistance is greatly appreciated. thanks!