Excel Forum

Excel Magic Trick 644: Recorded Macro And Formulas To Re-Arrange Data Set

See how to create a Recorded Macro that uses formulas to rearrange a proper data set to one listed in a column. Learn about:
1. Relative References in a Recorded Macro
2. Formulas to join data in the middle of a Recorded Macro
3. CHAR(1) function to add word wrap in a formula
4. Where to locate selected cells during a Relative Reference Recorded Macro.

Got a Question? Ask it Here in the Forum.