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
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK | AL | AM | AN | AO | AP | AQ | AR | AS | AT | AU | AV | AW | AX | AY | AZ | BA | BB | BC | BD | BE | BF | BG | BH | BI | BJ | BK | BL | BM | BN | BO | BP | BQ | BR | BS | BT | BU | BV | BW | BX | BY | BZ | CA | CB | CC | CD | CE | CF | CG | CH | CI | CJ | CK | CL | CM | CN | CO | CP | CQ | CR | CS | CT | CU | CV | CW | CX | CY | CZ | DA | DB | DC | DD | DE | DF | DG | DH | DI | DJ | DK | DL | DM | DN | DO | DP | DQ | DR | DS | DT | DU | DV | DW | DX | |||
| 1 | date | name | asin | minprice | maxprice | stock | total_sales | monthly_sales | o0_name | o0_price | o0_stock | o1_name | o1_price | o1_stock | o2_name | o2_price | o2_stock | o3_name | o3_price | o3_stock | o4_name | o4_price | o4_stock | o5_name | o5_price | o5_stock | o6_name | o6_price | o6_stock | o7_name | o7_price | o7_stock | o8_name | o8_price | o8_stock | o9_name | o9_price | o9_stock | o10_name | o10_price | o10_stock | o11_name | o11_price | o11_stock | o12_name | o12_price | o12_stock | o13_name | o13_price | o13_stock | o14_name | o14_price | o14_stock | o15_name | o15_price | o15_stock | o16_name | o16_price | o16_stock | o17_name | o17_price | o17_stock | o18_name | o18_price | o18_stock | o19_name | o19_price | o19_stock | o20_name | o20_price | o20_stock | o21_name | o21_price | o21_stock | o22_name | o22_price | o22_stock | o23_name | o23_price | o23_stock | o24_name | o24_price | o24_stock | o25_name | o25_price | o25_stock | o26_name | o26_price | o26_stock | o27_name | o27_price | o27_stock | o28_name | o28_price | o28_stock | o29_name | o29_price | o29_stock | o30_name | o30_price | o30_stock | o31_name | o31_price | o31_stock | o32_name | o32_price | o32_stock | o33_name | o33_price | o33_stock | o34_name | o34_price | o34_stock | o35_name | o35_price | o35_stock | o36_name | o36_price | o36_stock | o37_name | o37_price | o37_stock | o38_name | o38_price | o38_stock | o39_name | o39_price | o39_stock | ||
| 2 | 31/05/2022 23:15:05 | Slippers Slipper Home Slipper Slippers Men Bathroom Slippers Indoor Slipper Home Slippers Indoor Slippers Indoor Slippers Woman | ABC | 0.85 | 5.94 | 25236 | 5110 | 546 | Cream,36-37(Fit 35-36) | 5.94 | 972 | Navy,44-45(Fit 43-44) | 5.94 | 961 | Pink,40-41(Fit 39-40) | 5.94 | 962 | Shoe brush,36-37(Fit 35-36) | 0.85 | 989 | Shoe brush,40-41(Fit 39-40) | 5.95 | 0 | Grey,42-43(Fit 41-42) | 5.94 | 949 | Cream,44-45(Fit 43-44) | 5.95 | 0 | Shoe brush,42-43(Fit 41-42) | 5.95 | 0 | Yellow,42-43(Fit 41-42) | 5.95 | 0 | Black,40-41(Fit 39-40) | 5.94 | 971 | Cream,42-43(Fit 41-42) | 5.95 | 0 | Grey,44-45(Fit 43-44) | 5.94 | 967 | Navy,38-39(Fit 37-38) | 5.95 | 0 | Yellow,44-45(Fit 43-44) | 5.95 | 0 | Grey,40-41(Fit 39-40) | 5.94 | 969 | Navy,42-43(Fit 41-42) | 5.94 | 962 | Yellow,38-39(Fit 37-38) | 5.94 | 987 | Black,38-39(Fit 37-38) | 5.94 | 969 | Pink,44-45(Fit 43-44) | 5.95 | 0 | Green,38-39(Fit 37-38) | 5.94 | 975 | Black,42-43(Fit 41-42) | 5.94 | 958 | Navy,40-41(Fit 39-40) | 5.94 | 960 | Green,36-37(Fit 35-36) | 5.94 | 981 | Grey,36-37(Fit 35-36) | 5.95 | 0 | Green,40-41(Fit 39-40) | 5.94 | 977 | Navy,36-37(Fit 35-36) | 5.95 | 0 | Pink,38-39(Fit 37-38) | 5.94 | 940 | Cream,40-41(Fit 39-40) | 5.94 | 973 | Shoe brush,38-39(Fit 37-38) | 5.95 | 0 | Green,42-43(Fit 41-42) | 5.94 | 978 | Grey,38-39(Fit 37-38) | 5.95 | 0 | Pink,36-37(Fit 35-36) | 5.94 | 965 | Cream,38-39(Fit 37-38) | 5.94 | 966 | Black,36-37(Fit 35-36) | 5.94 | 987 | Yellow,40-41(Fit 39-40) | 5.94 | 987 | Pink,42-43(Fit 41-42) | 5.95 | 0 | Black,44-45(Fit 43-44) | 5.94 | 955 | Green,44-45(Fit 43-44) | 5.94 | 983 | Yellow,36-37(Fit 35-36) | 5.94 | 993 | Shoe brush,44-45(Fit 43-44) | 5.95 | 0 | ||
| 3 | 31/05/2022 21:01:15 | Slippers Slipper Home Slipper Slippers Men Bathroom Slippers Indoor Slipper Home Slippers Indoor Slippers Indoor Slippers Woman | ABC | 0.85 | 5.94 | 25238 | 5104 | 546 | Navy,38-39(Fit 37-38) | 5.95 | 0 | Grey,40-41(Fit 39-40) | 5.94 | 970 | Shoe brush,42-43(Fit 41-42) | 5.95 | 0 | Pink,40-41(Fit 39-40) | 5.94 | 962 | Grey,42-43(Fit 41-42) | 5.94 | 949 | Grey,38-39(Fit 37-38) | 5.95 | 0 | Yellow,36-37(Fit 35-36) | 5.94 | 993 | Black,42-43(Fit 41-42) | 5.94 | 958 | Navy,44-45(Fit 43-44) | 5.94 | 961 | Pink,42-43(Fit 41-42) | 5.95 | 0 | Shoe brush,44-45(Fit 43-44) | 5.95 | 0 | Grey,44-45(Fit 43-44) | 5.94 | 967 | Yellow,38-39(Fit 37-38) | 5.94 | 987 | Green,44-45(Fit 43-44) | 5.94 | 983 | Green,42-43(Fit 41-42) | 5.94 | 978 | Pink,44-45(Fit 43-44) | 5.95 | 0 | Cream,38-39(Fit 37-38) | 5.94 | 967 | Navy,36-37(Fit 35-36) | 5.95 | 0 | Black,44-45(Fit 43-44) | 5.94 | 955 | Navy,40-41(Fit 39-40) | 5.94 | 960 | Navy,42-43(Fit 41-42) | 5.94 | 962 | Shoe brush,38-39(Fit 37-38) | 5.95 | 0 | Shoe brush,40-41(Fit 39-40) | 5.95 | 0 | Cream,42-43(Fit 41-42) | 5.95 | 0 | Cream,44-45(Fit 43-44) | 5.95 | 0 | Green,36-37(Fit 35-36) | 5.94 | 981 | Grey,36-37(Fit 35-36) | 5.95 | 0 | Green,40-41(Fit 39-40) | 5.94 | 977 | Black,36-37(Fit 35-36) | 5.94 | 987 | Yellow,40-41(Fit 39-40) | 5.94 | 987 | Cream,36-37(Fit 35-36) | 5.94 | 972 | Yellow,42-43(Fit 41-42) | 5.95 | 0 | Yellow,44-45(Fit 43-44) | 5.95 | 0 | Black,40-41(Fit 39-40) | 5.94 | 971 | Green,38-39(Fit 37-38) | 5.94 | 975 | Black,38-39(Fit 37-38) | 5.94 | 969 | Shoe brush,36-37(Fit 35-36) | 0.85 | 989 | Pink,36-37(Fit 35-36) | 5.94 | 965 | Pink,38-39(Fit 37-38) | 5.94 | 940 | Cream,40-41(Fit 39-40) | 5.94 | 973 | ||
| 4 | 31/05/2022 19:15:05 | Slippers Slipper Home Slipper Slippers Men Bathroom Slippers Indoor Slipper Home Slippers Indoor Slippers Indoor Slippers Woman | ABC | 0.85 | 5.94 | 25243 | 5102 | 546 | Green,44-45(Fit 43-44) | 5.94 | 983 | Cream,42-43(Fit 41-42) | 5.95 | 0 | Cream,40-41(Fit 39-40) | 5.94 | 974 | Black,38-39(Fit 37-38) | 5.94 | 969 | Pink,44-45(Fit 43-44) | 5.95 | 0 | Pink,42-43(Fit 41-42) | 5.95 | 0 | Shoe brush,40-41(Fit 39-40) | 5.95 | 0 | Shoe brush,36-37(Fit 35-36) | 0.85 | 989 | Black,36-37(Fit 35-36) | 5.94 | 987 | Grey,38-39(Fit 37-38) | 5.95 | 0 | Green,42-43(Fit 41-42) | 5.94 | 978 | Pink,36-37(Fit 35-36) | 5.94 | 965 | Cream,38-39(Fit 37-38) | 5.94 | 968 | Yellow,36-37(Fit 35-36) | 5.94 | 993 | Cream,44-45(Fit 43-44) | 5.95 | 0 | Navy,42-43(Fit 41-42) | 5.94 | 963 | Shoe brush,44-45(Fit 43-44) | 5.95 | 0 | Yellow,38-39(Fit 37-38) | 5.94 | 987 | Shoe brush,42-43(Fit 41-42) | 5.95 | 0 | Yellow,40-41(Fit 39-40) | 5.94 | 987 | Grey,42-43(Fit 41-42) | 5.94 | 949 | Yellow,44-45(Fit 43-44) | 5.95 | 0 | Navy,38-39(Fit 37-38) | 5.95 | 0 | Green,40-41(Fit 39-40) | 5.94 | 977 | Green,38-39(Fit 37-38) | 5.94 | 975 | Shoe brush,38-39(Fit 37-38) | 5.95 | 0 | Navy,36-37(Fit 35-36) | 5.95 | 0 | Black,40-41(Fit 39-40) | 5.94 | 971 | Navy,44-45(Fit 43-44) | 5.94 | 961 | Grey,40-41(Fit 39-40) | 5.94 | 971 | Cream,36-37(Fit 35-36) | 5.94 | 972 | Grey,36-37(Fit 35-36) | 5.95 | 0 | Yellow,42-43(Fit 41-42) | 5.95 | 0 | Pink,38-39(Fit 37-38) | 5.94 | 941 | Green,36-37(Fit 35-36) | 5.94 | 981 | Navy,40-41(Fit 39-40) | 5.94 | 960 | Black,44-45(Fit 43-44) | 5.94 | 955 | Black,42-43(Fit 41-42) | 5.94 | 958 | Pink,40-41(Fit 39-40) | 5.94 | 962 | Grey,44-45(Fit 43-44) | 5.94 | 967 | ||
| 5 | 31/05/2022 15:22:05 | Slippers Slipper Home Slipper Slippers Men Bathroom Slippers Indoor Slipper Home Slippers Indoor Slippers Indoor Slippers Woman | ABC | 0.85 | 5.94 | 25244 | 5099 | 546 | Pink,44-45(Fit 43-44) | 5.95 | 0 | Black,38-39(Fit 37-38) | 5.94 | 970 | Green,44-45(Fit 43-44) | 5.94 | 983 | Shoe brush,38-39(Fit 37-38) | 5.95 | 0 | Shoe brush,44-45(Fit 43-44) | 5.95 | 0 | Yellow,44-45(Fit 43-44) | 5.95 | 0 | Yellow,38-39(Fit 37-38) | 5.94 | 987 | Cream,38-39(Fit 37-38) | 5.94 | 968 | Black,40-41(Fit 39-40) | 5.94 | 971 | Navy,36-37(Fit 35-36) | 5.95 | 0 | Green,40-41(Fit 39-40) | 5.94 | 977 | Navy,40-41(Fit 39-40) | 5.94 | 960 | Navy,38-39(Fit 37-38) | 5.95 | 0 | Grey,44-45(Fit 43-44) | 5.94 | 967 | Cream,36-37(Fit 35-36) | 5.94 | 972 | Pink,38-39(Fit 37-38) | 5.94 | 941 | Pink,42-43(Fit 41-42) | 5.95 | 0 | Green,42-43(Fit 41-42) | 5.94 | 978 | Shoe brush,36-37(Fit 35-36) | 0.85 | 989 | Grey,40-41(Fit 39-40) | 5.94 | 971 | Cream,44-45(Fit 43-44) | 5.95 | 0 | Pink,40-41(Fit 39-40) | 5.94 | 962 | Grey,38-39(Fit 37-38) | 5.95 | 0 | Cream,42-43(Fit 41-42) | 5.95 | 0 | Yellow,42-43(Fit 41-42) | 5.95 | 0 | Black,36-37(Fit 35-36) | 5.94 | 987 | Navy,42-43(Fit 41-42) | 5.94 | 963 | Green,36-37(Fit 35-36) | 5.94 | 981 | Black,42-43(Fit 41-42) | 5.94 | 958 | Pink,36-37(Fit 35-36) | 5.94 | 965 | Yellow,36-37(Fit 35-36) | 5.94 | 993 | Black,44-45(Fit 43-44) | 5.94 | 955 | Cream,40-41(Fit 39-40) | 5.94 | 974 | Shoe brush,42-43(Fit 41-42) | 5.95 | 0 | Grey,36-37(Fit 35-36) | 5.95 | 0 | Shoe brush,40-41(Fit 39-40) | 5.95 | 0 | Green,38-39(Fit 37-38) | 5.94 | 975 | Navy,44-45(Fit 43-44) | 5.94 | 961 | Grey,42-43(Fit 41-42) | 5.94 | 949 | Yellow,40-41(Fit 39-40) | 5.94 | 987 | ||
| 6 | 31/05/2022 15:15:05 | Slippers Slipper Home Slipper Slippers Men Bathroom Slippers Indoor Slipper Home Slippers Indoor Slippers Indoor Slippers Woman | ABC | 0.85 | 5.94 | 25244 | 5099 | 546 | Pink,44-45(Fit 43-44) | 5.95 | 0 | Black,38-39(Fit 37-38) | 5.94 | 970 | Green,44-45(Fit 43-44) | 5.94 | 983 | Shoe brush,38-39(Fit 37-38) | 5.95 | 0 | Shoe brush,44-45(Fit 43-44) | 5.95 | 0 | Yellow,44-45(Fit 43-44) | 5.95 | 0 | Yellow,38-39(Fit 37-38) | 5.94 | 987 | Cream,38-39(Fit 37-38) | 5.94 | 968 | Black,40-41(Fit 39-40) | 5.94 | 971 | Navy,36-37(Fit 35-36) | 5.95 | 0 | Green,40-41(Fit 39-40) | 5.94 | 977 | Navy,40-41(Fit 39-40) | 5.94 | 960 | Navy,38-39(Fit 37-38) | 5.95 | 0 | Grey,44-45(Fit 43-44) | 5.94 | 967 | Cream,36-37(Fit 35-36) | 5.94 | 972 | Pink,38-39(Fit 37-38) | 5.94 | 941 | Pink,42-43(Fit 41-42) | 5.95 | 0 | Green,42-43(Fit 41-42) | 5.94 | 978 | Shoe brush,36-37(Fit 35-36) | 0.85 | 989 | Grey,40-41(Fit 39-40) | 5.94 | 971 | Cream,44-45(Fit 43-44) | 5.95 | 0 | Pink,40-41(Fit 39-40) | 5.94 | 962 | Grey,38-39(Fit 37-38) | 5.95 | 0 | Cream,42-43(Fit 41-42) | 5.95 | 0 | Yellow,42-43(Fit 41-42) | 5.95 | 0 | Black,36-37(Fit 35-36) | 5.94 | 987 | Navy,42-43(Fit 41-42) | 5.94 | 963 | Green,36-37(Fit 35-36) | 5.94 | 981 | Black,42-43(Fit 41-42) | 5.94 | 958 | Pink,36-37(Fit 35-36) | 5.94 | 965 | Yellow,36-37(Fit 35-36) | 5.94 | 993 | Black,44-45(Fit 43-44) | 5.94 | 955 | Cream,40-41(Fit 39-40) | 5.94 | 974 | Shoe brush,42-43(Fit 41-42) | 5.95 | 0 | Grey,36-37(Fit 35-36) | 5.95 | 0 | Shoe brush,40-41(Fit 39-40) | 5.95 | 0 | Green,38-39(Fit 37-38) | 5.94 | 975 | Navy,44-45(Fit 43-44) | 5.94 | 961 | Grey,42-43(Fit 41-42) | 5.94 | 949 | Yellow,40-41(Fit 39-40) | 5.94 | 987 | ||
| 7 | 31/05/2022 11:15:06 | Slippers Slipper Home Slipper Slippers Men Bathroom Slippers Indoor Slipper Home Slippers Indoor Slippers Indoor Slippers Woman | ABC | 0.85 | 5.94 | 25247 | 5094 | 546 | Black,44-45(Fit 43-44) | 5.94 | 955 | Black,42-43(Fit 41-42) | 5.94 | 958 | Navy,36-37(Fit 35-36) | 5.95 | 0 | Cream,40-41(Fit 39-40) | 5.94 | 974 | Green,44-45(Fit 43-44) | 5.94 | 983 | Yellow,40-41(Fit 39-40) | 5.94 | 987 | Cream,38-39(Fit 37-38) | 5.94 | 968 | Shoe brush,44-45(Fit 43-44) | 5.95 | 0 | Navy,38-39(Fit 37-38) | 5.95 | 0 | Navy,42-43(Fit 41-42) | 5.94 | 963 | Black,36-37(Fit 35-36) | 5.94 | 987 | Shoe brush,36-37(Fit 35-36) | 0.85 | 989 | Cream,36-37(Fit 35-36) | 5.94 | 972 | Grey,44-45(Fit 43-44) | 5.94 | 967 | Green,36-37(Fit 35-36) | 5.94 | 981 | Black,40-41(Fit 39-40) | 5.94 | 972 | Green,40-41(Fit 39-40) | 5.94 | 978 | Shoe brush,38-39(Fit 37-38) | 5.95 | 0 | Yellow,44-45(Fit 43-44) | 5.95 | 0 | Pink,38-39(Fit 37-38) | 5.94 | 941 | Yellow,36-37(Fit 35-36) | 5.94 | 993 | Grey,42-43(Fit 41-42) | 5.94 | 949 | Grey,40-41(Fit 39-40) | 5.94 | 971 | Shoe brush,40-41(Fit 39-40) | 5.95 | 0 | Shoe brush,42-43(Fit 41-42) | 5.95 | 0 | Yellow,38-39(Fit 37-38) | 5.94 | 987 | Pink,42-43(Fit 41-42) | 5.95 | 0 | Grey,38-39(Fit 37-38) | 5.95 | 0 | Black,38-39(Fit 37-38) | 5.94 | 970 | Pink,44-45(Fit 43-44) | 5.95 | 0 | Cream,42-43(Fit 41-42) | 5.95 | 0 | Cream,44-45(Fit 43-44) | 5.95 | 0 | Pink,40-41(Fit 39-40) | 5.94 | 962 | Green,42-43(Fit 41-42) | 5.94 | 978 | Pink,36-37(Fit 35-36) | 5.94 | 965 | Yellow,42-43(Fit 41-42) | 5.95 | 0 | Navy,40-41(Fit 39-40) | 5.94 | 961 | Green,38-39(Fit 37-38) | 5.94 | 975 | Grey,36-37(Fit 35-36) | 5.95 | 0 | Navy,44-45(Fit 43-44) | 5.94 | 961 | ||
Sheet1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
