How to automatically add rows of SKU "parts" under under a row with the parent SKU

donjuanjuarez

New Member
Joined
Feb 20, 2015
Messages
1
Here is what I'm trying to do - I am with an ecommerce company and we need to export our international packages to a 3rd party for fulfillment. We create a CSV file with all orders - some orders are just individual product SKU's and other orders contain "Bundle" SKU's (which have multiple product SKU's within).

I am trying to create an automatic update so that IF there is a Bundle SKU, then Excel will automatically add rows of individual SKU's, its price, quantity and extended price.

Example 1 - our CURRENT exported order file:

Order NumberBox 1WeightOrder DateFirst NameLast NameAddress 1Address 2Address CityAddress StateAddress Postal CodeAddress CountrySKUItem DescriptionQuantityPriceExtended Price
12345Box 122/20/2015DonJuan123 Main StSuite 1San FranciscoCA34117USBUNDLE1Holiday Bundle1$100$100

<tbody>
</tbody>


Example 2 - our DESIRED order file (which should retrieve Bundle contents from another worksheet/file). This is what I'd like to try and produce, where the Order 12345 has the individual items listed out:

Order NumberWeightOrder DateFirst NameLast NameAddress 1Address 2Address CityAddress StateAddress Postal CodeAddress CountrySKUItem DescriptionQuantityPriceExtended Price
12345
2
2/20/2015
Don
Juan
123 Main St
Suite 1
San Francisco
CA
34117
US
BUNDLE1
Holiday Bundle
1
$100
$100
12345.52/20/15DonJuan123 Main StSuite 1San FranciscoCA34117USLotion101Lotion2$20$40
12345.52/20/15DonJuan123 Main StSuite 1San FranciscoCA34117USShamp101Shampoo2$20$40
1234512/20/15DonJuan123 Main StSuite 1San FranciscoCA34117USCleaner101Cleaner1$20$20
12346
1.5
2/21/2015
Jon
Doe
111 Main St.
Nowhere
GA
12345
US
Lotion101
Lotion
3$20
$60

<tbody>
</tbody>
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Watch MrExcel Video

Forum statistics

Threads
1,129,804
Messages
5,638,455
Members
417,025
Latest member
MusterDuster

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