How can I sort Individual Rows A to Z from Column I to Column DX with 3 Columns Groups Together (Name, Price and Stock)

Goodluckboss

New Member
Joined
May 25, 2014
Messages
25
Hi guys, I have an issue.

For some reasons, when I pull data from the source, the variations (options) name will keep moving between different columns so it is hard for me to keep track of the change in stock level

I have attached an excel spreadsheet with data for reference. How can I run a VBA to sort each individual row so that it sorts A to Z so that each column will have the SAME variation name

It starts from Column I and ends at Column DX and the Name, Price and Stock must move together as they are for that option name.

Thank you

Test.xlsx
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECFCGCHCICJCKCLCMCNCOCPCQCRCSCTCUCVCWCXCYCZDADBDCDDDEDFDGDHDIDJDKDLDMDNDODPDQDRDSDTDUDVDWDX
1datenameasinminpricemaxpricestocktotal_salesmonthly_saleso0_nameo0_priceo0_stocko1_nameo1_priceo1_stocko2_nameo2_priceo2_stocko3_nameo3_priceo3_stocko4_nameo4_priceo4_stocko5_nameo5_priceo5_stocko6_nameo6_priceo6_stocko7_nameo7_priceo7_stocko8_nameo8_priceo8_stocko9_nameo9_priceo9_stocko10_nameo10_priceo10_stocko11_nameo11_priceo11_stocko12_nameo12_priceo12_stocko13_nameo13_priceo13_stocko14_nameo14_priceo14_stocko15_nameo15_priceo15_stocko16_nameo16_priceo16_stocko17_nameo17_priceo17_stocko18_nameo18_priceo18_stocko19_nameo19_priceo19_stocko20_nameo20_priceo20_stocko21_nameo21_priceo21_stocko22_nameo22_priceo22_stocko23_nameo23_priceo23_stocko24_nameo24_priceo24_stocko25_nameo25_priceo25_stocko26_nameo26_priceo26_stocko27_nameo27_priceo27_stocko28_nameo28_priceo28_stocko29_nameo29_priceo29_stocko30_nameo30_priceo30_stocko31_nameo31_priceo31_stocko32_nameo32_priceo32_stocko33_nameo33_priceo33_stocko34_nameo34_priceo34_stocko35_nameo35_priceo35_stocko36_nameo36_priceo36_stocko37_nameo37_priceo37_stocko38_nameo38_priceo38_stocko39_nameo39_priceo39_stock
231/05/2022 23:15:05Slippers Slipper Home Slipper Slippers Men Bathroom Slippers Indoor Slipper Home Slippers Indoor Slippers Indoor Slippers WomanABC0.855.94252365110546Cream,36-37(Fit 35-36)5.94972Navy,44-45(Fit 43-44)5.94961Pink,40-41(Fit 39-40)5.94962Shoe brush,36-37(Fit 35-36)0.85989Shoe brush,40-41(Fit 39-40)5.950Grey,42-43(Fit 41-42)5.94949Cream,44-45(Fit 43-44)5.950Shoe brush,42-43(Fit 41-42)5.950Yellow,42-43(Fit 41-42)5.950Black,40-41(Fit 39-40)5.94971Cream,42-43(Fit 41-42)5.950Grey,44-45(Fit 43-44)5.94967Navy,38-39(Fit 37-38)5.950Yellow,44-45(Fit 43-44)5.950Grey,40-41(Fit 39-40)5.94969Navy,42-43(Fit 41-42)5.94962Yellow,38-39(Fit 37-38)5.94987Black,38-39(Fit 37-38)5.94969Pink,44-45(Fit 43-44)5.950Green,38-39(Fit 37-38)5.94975Black,42-43(Fit 41-42)5.94958Navy,40-41(Fit 39-40)5.94960Green,36-37(Fit 35-36)5.94981Grey,36-37(Fit 35-36)5.950Green,40-41(Fit 39-40)5.94977Navy,36-37(Fit 35-36)5.950Pink,38-39(Fit 37-38)5.94940Cream,40-41(Fit 39-40)5.94973Shoe brush,38-39(Fit 37-38)5.950Green,42-43(Fit 41-42)5.94978Grey,38-39(Fit 37-38)5.950Pink,36-37(Fit 35-36)5.94965Cream,38-39(Fit 37-38)5.94966Black,36-37(Fit 35-36)5.94987Yellow,40-41(Fit 39-40)5.94987Pink,42-43(Fit 41-42)5.950Black,44-45(Fit 43-44)5.94955Green,44-45(Fit 43-44)5.94983Yellow,36-37(Fit 35-36)5.94993Shoe brush,44-45(Fit 43-44)5.950
331/05/2022 21:01:15Slippers Slipper Home Slipper Slippers Men Bathroom Slippers Indoor Slipper Home Slippers Indoor Slippers Indoor Slippers WomanABC0.855.94252385104546Navy,38-39(Fit 37-38)5.950Grey,40-41(Fit 39-40)5.94970Shoe brush,42-43(Fit 41-42)5.950Pink,40-41(Fit 39-40)5.94962Grey,42-43(Fit 41-42)5.94949Grey,38-39(Fit 37-38)5.950Yellow,36-37(Fit 35-36)5.94993Black,42-43(Fit 41-42)5.94958Navy,44-45(Fit 43-44)5.94961Pink,42-43(Fit 41-42)5.950Shoe brush,44-45(Fit 43-44)5.950Grey,44-45(Fit 43-44)5.94967Yellow,38-39(Fit 37-38)5.94987Green,44-45(Fit 43-44)5.94983Green,42-43(Fit 41-42)5.94978Pink,44-45(Fit 43-44)5.950Cream,38-39(Fit 37-38)5.94967Navy,36-37(Fit 35-36)5.950Black,44-45(Fit 43-44)5.94955Navy,40-41(Fit 39-40)5.94960Navy,42-43(Fit 41-42)5.94962Shoe brush,38-39(Fit 37-38)5.950Shoe brush,40-41(Fit 39-40)5.950Cream,42-43(Fit 41-42)5.950Cream,44-45(Fit 43-44)5.950Green,36-37(Fit 35-36)5.94981Grey,36-37(Fit 35-36)5.950Green,40-41(Fit 39-40)5.94977Black,36-37(Fit 35-36)5.94987Yellow,40-41(Fit 39-40)5.94987Cream,36-37(Fit 35-36)5.94972Yellow,42-43(Fit 41-42)5.950Yellow,44-45(Fit 43-44)5.950Black,40-41(Fit 39-40)5.94971Green,38-39(Fit 37-38)5.94975Black,38-39(Fit 37-38)5.94969Shoe brush,36-37(Fit 35-36)0.85989Pink,36-37(Fit 35-36)5.94965Pink,38-39(Fit 37-38)5.94940Cream,40-41(Fit 39-40)5.94973
431/05/2022 19:15:05Slippers Slipper Home Slipper Slippers Men Bathroom Slippers Indoor Slipper Home Slippers Indoor Slippers Indoor Slippers WomanABC0.855.94252435102546Green,44-45(Fit 43-44)5.94983Cream,42-43(Fit 41-42)5.950Cream,40-41(Fit 39-40)5.94974Black,38-39(Fit 37-38)5.94969Pink,44-45(Fit 43-44)5.950Pink,42-43(Fit 41-42)5.950Shoe brush,40-41(Fit 39-40)5.950Shoe brush,36-37(Fit 35-36)0.85989Black,36-37(Fit 35-36)5.94987Grey,38-39(Fit 37-38)5.950Green,42-43(Fit 41-42)5.94978Pink,36-37(Fit 35-36)5.94965Cream,38-39(Fit 37-38)5.94968Yellow,36-37(Fit 35-36)5.94993Cream,44-45(Fit 43-44)5.950Navy,42-43(Fit 41-42)5.94963Shoe brush,44-45(Fit 43-44)5.950Yellow,38-39(Fit 37-38)5.94987Shoe brush,42-43(Fit 41-42)5.950Yellow,40-41(Fit 39-40)5.94987Grey,42-43(Fit 41-42)5.94949Yellow,44-45(Fit 43-44)5.950Navy,38-39(Fit 37-38)5.950Green,40-41(Fit 39-40)5.94977Green,38-39(Fit 37-38)5.94975Shoe brush,38-39(Fit 37-38)5.950Navy,36-37(Fit 35-36)5.950Black,40-41(Fit 39-40)5.94971Navy,44-45(Fit 43-44)5.94961Grey,40-41(Fit 39-40)5.94971Cream,36-37(Fit 35-36)5.94972Grey,36-37(Fit 35-36)5.950Yellow,42-43(Fit 41-42)5.950Pink,38-39(Fit 37-38)5.94941Green,36-37(Fit 35-36)5.94981Navy,40-41(Fit 39-40)5.94960Black,44-45(Fit 43-44)5.94955Black,42-43(Fit 41-42)5.94958Pink,40-41(Fit 39-40)5.94962Grey,44-45(Fit 43-44)5.94967
531/05/2022 15:22:05Slippers Slipper Home Slipper Slippers Men Bathroom Slippers Indoor Slipper Home Slippers Indoor Slippers Indoor Slippers WomanABC0.855.94252445099546Pink,44-45(Fit 43-44)5.950Black,38-39(Fit 37-38)5.94970Green,44-45(Fit 43-44)5.94983Shoe brush,38-39(Fit 37-38)5.950Shoe brush,44-45(Fit 43-44)5.950Yellow,44-45(Fit 43-44)5.950Yellow,38-39(Fit 37-38)5.94987Cream,38-39(Fit 37-38)5.94968Black,40-41(Fit 39-40)5.94971Navy,36-37(Fit 35-36)5.950Green,40-41(Fit 39-40)5.94977Navy,40-41(Fit 39-40)5.94960Navy,38-39(Fit 37-38)5.950Grey,44-45(Fit 43-44)5.94967Cream,36-37(Fit 35-36)5.94972Pink,38-39(Fit 37-38)5.94941Pink,42-43(Fit 41-42)5.950Green,42-43(Fit 41-42)5.94978Shoe brush,36-37(Fit 35-36)0.85989Grey,40-41(Fit 39-40)5.94971Cream,44-45(Fit 43-44)5.950Pink,40-41(Fit 39-40)5.94962Grey,38-39(Fit 37-38)5.950Cream,42-43(Fit 41-42)5.950Yellow,42-43(Fit 41-42)5.950Black,36-37(Fit 35-36)5.94987Navy,42-43(Fit 41-42)5.94963Green,36-37(Fit 35-36)5.94981Black,42-43(Fit 41-42)5.94958Pink,36-37(Fit 35-36)5.94965Yellow,36-37(Fit 35-36)5.94993Black,44-45(Fit 43-44)5.94955Cream,40-41(Fit 39-40)5.94974Shoe brush,42-43(Fit 41-42)5.950Grey,36-37(Fit 35-36)5.950Shoe brush,40-41(Fit 39-40)5.950Green,38-39(Fit 37-38)5.94975Navy,44-45(Fit 43-44)5.94961Grey,42-43(Fit 41-42)5.94949Yellow,40-41(Fit 39-40)5.94987
631/05/2022 15:15:05Slippers Slipper Home Slipper Slippers Men Bathroom Slippers Indoor Slipper Home Slippers Indoor Slippers Indoor Slippers WomanABC0.855.94252445099546Pink,44-45(Fit 43-44)5.950Black,38-39(Fit 37-38)5.94970Green,44-45(Fit 43-44)5.94983Shoe brush,38-39(Fit 37-38)5.950Shoe brush,44-45(Fit 43-44)5.950Yellow,44-45(Fit 43-44)5.950Yellow,38-39(Fit 37-38)5.94987Cream,38-39(Fit 37-38)5.94968Black,40-41(Fit 39-40)5.94971Navy,36-37(Fit 35-36)5.950Green,40-41(Fit 39-40)5.94977Navy,40-41(Fit 39-40)5.94960Navy,38-39(Fit 37-38)5.950Grey,44-45(Fit 43-44)5.94967Cream,36-37(Fit 35-36)5.94972Pink,38-39(Fit 37-38)5.94941Pink,42-43(Fit 41-42)5.950Green,42-43(Fit 41-42)5.94978Shoe brush,36-37(Fit 35-36)0.85989Grey,40-41(Fit 39-40)5.94971Cream,44-45(Fit 43-44)5.950Pink,40-41(Fit 39-40)5.94962Grey,38-39(Fit 37-38)5.950Cream,42-43(Fit 41-42)5.950Yellow,42-43(Fit 41-42)5.950Black,36-37(Fit 35-36)5.94987Navy,42-43(Fit 41-42)5.94963Green,36-37(Fit 35-36)5.94981Black,42-43(Fit 41-42)5.94958Pink,36-37(Fit 35-36)5.94965Yellow,36-37(Fit 35-36)5.94993Black,44-45(Fit 43-44)5.94955Cream,40-41(Fit 39-40)5.94974Shoe brush,42-43(Fit 41-42)5.950Grey,36-37(Fit 35-36)5.950Shoe brush,40-41(Fit 39-40)5.950Green,38-39(Fit 37-38)5.94975Navy,44-45(Fit 43-44)5.94961Grey,42-43(Fit 41-42)5.94949Yellow,40-41(Fit 39-40)5.94987
731/05/2022 11:15:06Slippers Slipper Home Slipper Slippers Men Bathroom Slippers Indoor Slipper Home Slippers Indoor Slippers Indoor Slippers WomanABC0.855.94252475094546Black,44-45(Fit 43-44)5.94955Black,42-43(Fit 41-42)5.94958Navy,36-37(Fit 35-36)5.950Cream,40-41(Fit 39-40)5.94974Green,44-45(Fit 43-44)5.94983Yellow,40-41(Fit 39-40)5.94987Cream,38-39(Fit 37-38)5.94968Shoe brush,44-45(Fit 43-44)5.950Navy,38-39(Fit 37-38)5.950Navy,42-43(Fit 41-42)5.94963Black,36-37(Fit 35-36)5.94987Shoe brush,36-37(Fit 35-36)0.85989Cream,36-37(Fit 35-36)5.94972Grey,44-45(Fit 43-44)5.94967Green,36-37(Fit 35-36)5.94981Black,40-41(Fit 39-40)5.94972Green,40-41(Fit 39-40)5.94978Shoe brush,38-39(Fit 37-38)5.950Yellow,44-45(Fit 43-44)5.950Pink,38-39(Fit 37-38)5.94941Yellow,36-37(Fit 35-36)5.94993Grey,42-43(Fit 41-42)5.94949Grey,40-41(Fit 39-40)5.94971Shoe brush,40-41(Fit 39-40)5.950Shoe brush,42-43(Fit 41-42)5.950Yellow,38-39(Fit 37-38)5.94987Pink,42-43(Fit 41-42)5.950Grey,38-39(Fit 37-38)5.950Black,38-39(Fit 37-38)5.94970Pink,44-45(Fit 43-44)5.950Cream,42-43(Fit 41-42)5.950Cream,44-45(Fit 43-44)5.950Pink,40-41(Fit 39-40)5.94962Green,42-43(Fit 41-42)5.94978Pink,36-37(Fit 35-36)5.94965Yellow,42-43(Fit 41-42)5.950Navy,40-41(Fit 39-40)5.94961Green,38-39(Fit 37-38)5.94975Grey,36-37(Fit 35-36)5.950Navy,44-45(Fit 43-44)5.94961
Sheet1
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
2022-06-24_18-34-22.jpg


Insert an image for better context
 
Upvote 0

Forum statistics

Threads
1,224,820
Messages
6,181,162
Members
453,021
Latest member
Justyna P

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