Hello, I want a macro that will look at columns F through K and:
Note that if a cell in columns F-K has a value, then the corresponding cell in the preceeding column always has a value.
Before:
<tbody>
</tbody>
After:
<tbody>
</tbody>
- If a cell in those columns contains a value, then insert a row after
- Transpose the value to column E
- (Optional) auto-fill columns A, B, C, and D with the preceeding value
Note that if a cell in columns F-K has a value, then the corresponding cell in the preceeding column always has a value.
Before:
A | B | C | D | E | F | G | H | I | J | K |
100 | abc | fall | blue | hand | back | hip | ||||
200 | def | spring | red | thigh | head | |||||
300 | ghi | winter | green | arm | neck | shoulder | wrist | elbow | knee | ankle |
400 | jkl | summer | yellow | abdomen |
<tbody>
</tbody>
After:
A | B | C | D | E | F | G | H | I | J | K |
100 | abc | fall | blue | hand | ||||||
100 | abc | fall | blue | back | ||||||
100 | abc | fall | blue | hip | ||||||
200 | def | spring | red | thigh | ||||||
200 | def | spring | red | head | ||||||
300 | ghi | winter | green | arm | ||||||
300 | ghi | winter | green | neck | ||||||
300 | ghi | winter | green | shoulder | ||||||
300 | ghi | winter | green | wrist | ||||||
300 | ghi | winter | green | elbow | ||||||
300 | ghi | winter | green | knee | ||||||
300 | ghi | winter | green | ankle | ||||||
400 | jkl | summer | yellow | abdomen |
<tbody>
</tbody>