Insert Row based on Cell contents and copy data from Row above and paste data from another tab

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
DayRoute ReferenceShift StartDepot NameCustomer IDCustomer NameCustomer AddressPostcodeArrival TimeDepart TimeProduct NameCall TypeOrder Details 1
Tue100/01108:19PPARKDEPOT08:5109:21C
Tue100/01108:19D39BKCUST 110:0010:30CPLACEHOLDER
Tue100/01108:19BHGZACUST 211:1211:42CPLACEHOLDER
Tue100/01108:19CRGPBCUST 312:3513:05CPLACEHOLDER
Tue100/01108:19HH2 XDOCK DEPOT13:4915:04D


Data Tab
TueD39BKEQNXA-TF
TueD39BK0264F-A2
TueBHGZA02641-JH
TueCRGPBEQNXA-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
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Forum statistics

Threads
1,223,893
Messages
6,175,239
Members
452,621
Latest member
Laura_PinksBTHFT

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top