Online Excel Sheet - Project Sheet

Project Sheet 1. Two different pages: "Projects In Progress", "Completed Projects" 2. Use the following for the Column Names (All columns should be sortable): Name - Drop Down Menu with the following options: Adam, Frank, Jon, Robin, Robert, Josh, Ruth, Jeff, Dave, Jake, Tom Date Assigned - Dates should be in the following format: Month/Day/Year... For Example: 8/30/07 Due Date - I would like a button that will open a calendar where I can choose the date to insert to this field. Dates should be in the following format: Month/Day/Year... For Example: 8/30/07 Priority - Drop Down Menu with the following options: Emergency, High, Low, Back Burner Title - Text Field Description - An Icon that you can click. Once clicked, it will open to a new page with a Text Area Field that will allow an unlimited amount of information to be entered and saved. Status Notes - An Icon that you can click. Once clicked, it will open to a new page with a Text Area Field that will allow an unlimited amount of information to be entered and saved. **Status - Drop Down Menu with the following options: Started, 1/2, Beta, Completed Delete - Delete button to delete the entry. This must have a confirmation box prior to deletion. **The Status Drop Down Menu will work similar to the Status from the MLS Online Spreadsheet. If "Completed" is selected, it will be moved to the "Completed Projects" list. All other fields under Status will keep the project listed under "In Progress" 3. In the top right of the page, I need two Additional Drop Down Menus. 1st Drop Down - Has the following options: In Progress, Completed. - In Progress will change to the "In Progress" List. Completed will change to the "Completed" List. These Lists should be on seperate pages. The drop down will switch between the pages, depending on the selection. 2nd Drop Down - Has the following options: All, Adam, Frank, Jon, Robin, Robert, Josh, Ruth, Jeff, Dave, Jake, Tom - This drop down will control what is viewed on the current list. For example: "All" will show all entries under the "Name" column. "Adam" will only display projects set to "Adam" under the "Name" column. 4. Have an "Add Project" button in the bottom left of the page. The "Add Project" button will have all of the above column names so I can insert specific information. 5. "Date Assigned" and "Title" should not be editable.