Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

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

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
3,843
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Jul 14, 2010

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.

  • likes, 0 dislikes

Link to this comment:

Share to:
see all

All Comments (6)

Sign In or Sign Up now to post a comment!
  • You are welcome! (I too need to use the MACRO Recorder more...)

  • Neat use of the macro recorder... Powerful tool, I need to use it more. Thanks for the video Mike.

  • You are welcome!

  • Thank You So much!!

  • You are welcome!

    You are right: If you know Excel, Employer will pay you more and unemployment is unlikely.

  • Cool video. Thanks for all the videos. You are going to make me rich! lol

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more