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
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Watch MrExcel Video

Forum statistics

Threads
1,127,560
Messages
5,625,506
Members
416,115
Latest member
Gonzo5711

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
Top