I need a macro for the following info
I have a 5 column list with a long row list that I want to take some of the info and but it into rows based on this criteria
This is all in Sheet1
Here is an example of items in the list....
A.................B
B12DST30....32
B12DST30....34
B12DST30....36
B12DST30....38
B74BRN30....30
B74BRN30....32
B74BRN32....30
B74BRN32....32
B74BRN32....34
C19BRNREG..SML
C19BRNREG..MED
C19BRNREG..LRG
I want to take all of the column A's items that are the same style and take Column B info and take the data and put it in a row format on Sheet2 starting with cell A1. Then do the same for the next item. Heres and example of what it should look like on Sheet2
A...................B.......C......D......E.......F
B12DST30......32.....34.....36....38
B74BRN30......30.....32
B74BRN32......30.....32.....34
C19BRNREG...SML...MED...LRG
Any Suggestions, there's got to be a way!!
I have a 5 column list with a long row list that I want to take some of the info and but it into rows based on this criteria
This is all in Sheet1
Here is an example of items in the list....
A.................B
B12DST30....32
B12DST30....34
B12DST30....36
B12DST30....38
B74BRN30....30
B74BRN30....32
B74BRN32....30
B74BRN32....32
B74BRN32....34
C19BRNREG..SML
C19BRNREG..MED
C19BRNREG..LRG
I want to take all of the column A's items that are the same style and take Column B info and take the data and put it in a row format on Sheet2 starting with cell A1. Then do the same for the next item. Heres and example of what it should look like on Sheet2
A...................B.......C......D......E.......F
B12DST30......32.....34.....36....38
B74BRN30......30.....32
B74BRN32......30.....32.....34
C19BRNREG...SML...MED...LRG
Any Suggestions, there's got to be a way!!