I am trying to create an Excel spreadsheet including a table in 1 column and 5 other columns (for random data). I have to protect the sheet to keep the users from modifying the format. I need the ability to filter from within the table to another worksheet for each topic in the table. I want the sheet to update as each record is entered with totals at the bottom of the worksheet. Any ideas?