I'm having a difficult time trying to create a macro or even a formula that does what I'm hoping to do. This is my first post here, so I don't know if I can include an attachment or not, so I will try to paste it in.
I would like to run a macro that will take the data from this...
Item A 0 0 0 0 0 0 5 11 20 35 44 67
Item B 0 0 9 10 16 20 22 25 34 36 32 20
Item C 66 68 70 72 75 80 81 80 81 79 78 77
Item D 0 12 20 50 55 63 72 80 88 89 90 92
Item E 20 22 18 15 10 9 7 5 2 1 0 0
to this...
Item A 11 20 35 44 67
Item B 10 16 20 22 25 34 36 32 20
Item D 12 20 50 55 63 72 80 88 89 90 92
To put into words, the first requirement is that the value in the first Cell for each Item must equal zero. If this condition is met, then proceed to step 2. As you can see, Items C & E did not meet the first requirement.
For step 2, if we look at Item A again, it is looking across the Row to determine when it first reaches 10 or more. For this case, it occurs in the 8th cell (value = 11). Once it finds this cell, it takes the value from that cell and the cells that follow and shifts them to the left to the beginning while still keeping the numbers in the same order.
Can this be done with a macro??
Dave
I would like to run a macro that will take the data from this...
Item A 0 0 0 0 0 0 5 11 20 35 44 67
Item B 0 0 9 10 16 20 22 25 34 36 32 20
Item C 66 68 70 72 75 80 81 80 81 79 78 77
Item D 0 12 20 50 55 63 72 80 88 89 90 92
Item E 20 22 18 15 10 9 7 5 2 1 0 0
to this...
Item A 11 20 35 44 67
Item B 10 16 20 22 25 34 36 32 20
Item D 12 20 50 55 63 72 80 88 89 90 92
To put into words, the first requirement is that the value in the first Cell for each Item must equal zero. If this condition is met, then proceed to step 2. As you can see, Items C & E did not meet the first requirement.
For step 2, if we look at Item A again, it is looking across the Row to determine when it first reaches 10 or more. For this case, it occurs in the 8th cell (value = 11). Once it finds this cell, it takes the value from that cell and the cells that follow and shifts them to the left to the beginning while still keeping the numbers in the same order.
Can this be done with a macro??
Dave