Automatically create new row based on a cell value.

Beachball21

New Member
Joined
Feb 2, 2021
Messages
6
Office Version
  1. 2016
Platform
  1. MacOS
Hi,

I have a file that has order data/rows and I am trying to break out and create new rows in it automatically based on a cell value in the memo column. For example,

In the the screenshot below (apologies for the screen shot as I am on mac and can't configure xl2bb as it is incompatible with my machine), I am trying to breakout row 2 and create new lines in the same sheet because the memo field has a specific value i.e. J-INT0000****. Withe new rows, the goal is to create them with the same value for all the other columns as it is in row 2, the only difference is that the memoe field will now old a single -INT value.

In this case this will result in 4 new rows created for this order (column d). Then rinse and repeat in the entire sheet for each unique order.

Is this possible in excel or will i have to use some other form of scripting to get this done?




2021-03-10_15-32-102.png
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Watch MrExcel Video

Forum statistics

Threads
1,129,485
Messages
5,636,606
Members
416,929
Latest member
Nitil

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