Hi Folks! I am back asking for your help. I receive a file in the following format. The rows that start with data in Column "A" are part numbers. Below those part numbers with data beginning starting in column "C" are accessory codes and accessory descriptions, pertaining to the part above. I am needing to have the accessory codes only appended to the part data row and moved to column"J", "K", "L", and so on depending on the number of accessories, which is variable according to the part order. The number of accessories could be between 0 and 25 per part. The number of parts could be in the thousands and varies with each order. Finally, I am needing the rows with the accessory codes to be deleted from the worksheet, so that I would end up with a would end up with only 5 rows of part information (Excluding headers) in the example below. Please scroll to the bottom for an example of what we need it to look like after manipulation, so that it can be imported into QuickBooks.
I worked on this for a couple of weeks trying various options, but the logic of getting this done beat my limited VBA knowledge. I appreciate your help.
<tbody>
</tbody>
<tbody>
</tbody>
I worked on this for a couple of weeks trying various options, but the logic of getting this done beat my limited VBA knowledge. I appreciate your help.
A | B | C | D | E | F | G | H | I | |
---|---|---|---|---|---|---|---|---|---|
1 | Mfg | Cat | Part Number | Part Description | Alias 1 | Alias 2 | Qty | Purchase | Sell |
2 | HON | HCG | H10584L | 10500 Series Single Pedestal Desk Left 66W x 30D | John's Office | 2nd Floor | 1 | 402.48 | 503.1 |
3 | $(L1STD) | Grd L1 Standard Laminates | |||||||
4 | .H | LAM: Bourbon Cherry | |||||||
5 | H | LAM: Bourbon Cherry | |||||||
6 | HON | HCG | H10515R | 10500 Series Right Return 29-1/2H x 48W x 24D | John's Office | 2nd Floor | 1 | 324.09 | 405.11 |
7 | $(L1STD) | Grd L1 Standard Laminates | |||||||
8 | .H | LAM: Bourbon Cherry | |||||||
9 | H | LAM: Bourbon Cherry | |||||||
10 | HON | HSN | HIWMM | Ignition 2 Task Mid-back, ilira back | John's Office | 2nd Floor | 1 | 292.11 | 365.14 |
11 | .Y2 | Advanced Synchro- Tilt | |||||||
12 | .A | Arm: Height and Width Adj. Arm | |||||||
13 | .H | Hard Caster | |||||||
14 | .IM | Mesh: Black | |||||||
15 | ($3) | GRADE: III UPHOLSTERY | |||||||
16 | .SX | Silvertex | |||||||
17 | 23 | COLOR: Carbon | |||||||
18 | .AL | Adjustable Lumbar | |||||||
19 | .SB | Base: Standard Base | |||||||
20 | .T | Frame: Black | |||||||
21 | ALS | AOP | P16536TP | Optimize Tckble Pnl 65H x 36W w/out Top Cap | Bucky's Office | 1st Floor | 4 | 201.24 | 251.55 |
22 | ALS | AOP | P16524TP | Optimize Tckble Pnl 65H x 24W w/out Top Cap | Bucky's Office | 1st Floor | 2 | 158.34 | 197.93 |
<tbody>
</tbody>
GIZA SIF DRAWING CSV(436)
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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Mfg | Cat | Part Number | Part Description | Alias 1 | Alias 2 | Qty | Purchase | Sell | A1 | A2 | A3 | A4 | A5 | A6 | A7 | A8 | A9 | A10 | A11 | A12 | A13 | A14 | A15 | A16 | A17 | A18 | A19 | A20 | A21 | A22 | A23 | A24 | A25 |
2 | HON | HCG | H10584L | 10500 Series Single Pedestal Desk Left 66W x 30D | John's Office | 2nd Floor | 1 | 402.48 | 503.1 | $(L1STD) | .H | H | ||||||||||||||||||||||
3 | HON | HCG | H10515R | 10500 Series Right Return 29-1/2H x 48W x 24D | John's Office | 2nd Floor | 1 | 324.09 | 405.11 | $(L1STD) | .H | H | ||||||||||||||||||||||
4 | HON | HSN | HIWMM | Ignition 2 Task Mid-back, ilira back | John's Office | 2nd Floor | 1 | 292.11 | 365.14 | .Y2 | .A | .H | .IM | ($3) | .SX | 23 | .AL | .SB | .T | |||||||||||||||
5 | ALS | AOP | P16536TP | Optimize Tckble Pnl 65H x 36W w/out Top Cap | Bucky's Office | 1st Floor | 4 | 201.24 | 251.55 | |||||||||||||||||||||||||
6 | ALS | AOP | P16524TP | Optimize Tckble Pnl 65H x 24W w/out Top Cap | Bucky's Office | 1st Floor | 2 | 158.34 | 197.93 |
<tbody>
</tbody>
GIZA SIF DRAWING CSV(436)