Andyjk1984
New Member
- Joined
- May 17, 2019
- Messages
- 11
Bit of a complicated one here, i will try to explain best as i can
Main Sheet
Data Tab
In Main sheet, "Order Details" column (M) when it contains 'Placeholder' insert new Row beneath it based on Day & Customer ID matching the Data tab so in the case of D39BK 2 new Rows will be added and cells A to L the data would be copied from the cell above but column M would be replaced with EQNXA TF for the first Row added and 0264F-A2 for the second Row added, and the same process for BHGZA & CRGPB 1 new row being added for them both with the same process.
hope this makes sense
and appreciate any advice help you can offer me
Main Sheet
Day | Route Reference | Shift Start | Depot Name | Customer ID | Customer Name | Customer Address | Postcode | Arrival Time | Depart Time | Product Name | Call Type | Order Details 1 |
Tue | 100/011 | 08:19 | PPARK | DEPOT | 08:51 | 09:21 | C | |||||
Tue | 100/011 | 08:19 | D39BK | CUST 1 | 10:00 | 10:30 | C | PLACEHOLDER | ||||
Tue | 100/011 | 08:19 | BHGZA | CUST 2 | 11:12 | 11:42 | C | PLACEHOLDER | ||||
Tue | 100/011 | 08:19 | CRGPB | CUST 3 | 12:35 | 13:05 | C | PLACEHOLDER | ||||
Tue | 100/011 | 08:19 | HH2 XDOCK | DEPOT | 13:49 | 15:04 | D | |||||
Data Tab
Tue | D39BK | EQNXA-TF |
Tue | D39BK | 0264F-A2 |
Tue | BHGZA | 02641-JH |
Tue | CRGPB | EQNXA-O4 |
In Main sheet, "Order Details" column (M) when it contains 'Placeholder' insert new Row beneath it based on Day & Customer ID matching the Data tab so in the case of D39BK 2 new Rows will be added and cells A to L the data would be copied from the cell above but column M would be replaced with EQNXA TF for the first Row added and 0264F-A2 for the second Row added, and the same process for BHGZA & CRGPB 1 new row being added for them both with the same process.
hope this makes sense
and appreciate any advice help you can offer me