Excel Forum



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.