Excel Forum
Similar Content
Convert an Incorrect Date Format into a Real Date in Excel
Tutorial: Change an incorrectly formatted/input date into the proper date format for Excel. This tut...
Sum Values from Every X Number of Rows in Excel
Tutorial: Add values from every x number of rows in Excel. For instance, add together every other va...
Simple Excel Function to Extract a Word or Text from a Cell
Tutorial: Excel function that makes it easy to extract a word or text from a cell in Excel. This is ...



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.