Excel Forum
Similar Content
Odd or Even Row Formulas in Excel
Tutorial: Formulas to determine if the current cell is odd or even; this allows you to perform speci...
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...

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.