Macro to sort values into three columns

hi i have a macro to copy values from a single column and sort them into three colums

i basically works, it finds marker 1 drops down a cell picks up the value then pastes into the corresponding column etc tec

cell "a1" holds the value for "marker 1"

this is the origional single column
marker 1
value 1 (--> goes into column 1)
value 2 (--> goes into column 2)
value 3 (--> goes into column 3)
marker 2
value 1 (--> goes into column 1)
value 2 (--> goes into column 2)
value 3 (--> goes into column 3)
marker 1
value 1 (--> goes into column 1)
value 2 (--> goes into column 2)
value 3 (--> goes into column 3)
marker 3
value 1 (--> goes into column 1)
value 2 (--> goes into column 2)
value 3 (--> goes into column 3)

(the problem is my macro pasts the values into the second and third colums but not into the first, then if i rerun the macro again it pastes the vale into the first column but not the second two)

Please Login or Register  to view this content.

Click GO ADVANCED and use the paperclip icon to post up a workbook showing exact BEFORE/AFTER sheets demonstrating what you're wanting to.

This will do the same job: (and much faster)

Please Login or Register  to view this content.