In a excel workbook I have two sheets called DB and List. Each of the sheets has a table in it. The DB table holds names, and each name can be either active or inactive (Initials are short for the name).
When I activate the List sheet, I want the initials column in the List table to populate only with names, that are active in the DB table. Notice that there are other columns in the list, that hold calculations, that depends on content in the Initials column.
When I leave the sheet List, by performance reasons I want the table to empty itself, but still keep the first row in it, so that the calculations remain. Let me know, if there are other ways to keep performance at a max.
Excel version 2007 on Windows XP