How To: Generate a dynamic list from a table in MS Excel

Generate a dynamic list from a table in MS Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 146th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from table, putting one record on each sheet with records in rows. This is accomplished with Excel's VLOOKUP, COLUMN, FIND, REPLACE and CELL functions. See also how to create a formula for a sheet name (sheet tab name, worksheet name).

(1) Part 1 of 2 - How to Generate a dynamic list from a table in MS Excel, (2) Part 2 of 2 - How to Generate a dynamic list from a table in MS Excel

It’s Cyber Monday on WonderHowTo! Don’t miss out on all the big sales in the Gadget Hacks shop and Null Byte shop. Use code CMSAVE20 to save on everything, and use CMSAVE40 for all things apps and software. For online courses, apply code CMSAVE70 for the biggest discounts.

Check out all of Gadget Hacks' CM 2020 deals >

Check out all of Null Byte's CM 2020 deals >

Our Best Phone Hacks

Gadget Hacks' tips — delivered daily.

Be the First to Comment

Share Your Thoughts

  • Hot
  • Latest