Excel Magic Trick # 146 part 1: Dynamic List from Table #1

Loading...

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

Uploaded by on Nov 19, 2008

See how to how to extract records from table and put 1 record on each sheet with records in rows. See how to use the functions; VLOOKUP, COLUMN, FIND, REPLACE, CELL functions. See how to create a formula for a sheet name (sheet tab name, worksheet name).

See how to insert new worksheets (sheets, sheet tabs) with Shift + F11. See how to copy worksheets. See how to name worksheet sheet tabs. Learn about a useful sheet tab naming trick.

  • likes, 0 dislikes

Link to this comment:

Share to:
see all

All Comments (0)

Sign In or Sign Up now to post a comment!
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