Excel Forum
Similar Content
Vlookup Date Picker in Excel (Dynamic)
Tutorial: Make a dynamically updating vlookup date picker for excel that allows you to choose a date...
Regular Expression Search Formula in Excel - Regex
Tutorial: Part 1 - Regular Expression Match Formula in Excel (No VBA) Part 2 - Complete Excel Reg...
Ignore Blanks in a Data Validation List in Excel
Tutorial: I will show you 3 ways to remove the blanks from a Data Validation dropdown menu in Excel...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




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


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.





Got a Question? Ask it Here in the Forum.