checkmarks and dropdowns

Hi guys! I am in the midst of searching for this information, but so far most of it is a little above my level of understanding. If anyone could provide assistance, I would appreciate it.

I need to take the attached excel file and do the following:

1. On the sheet named Current, I need to make all the cells under rows D thru I to where a checkmark will be put in when double-clicked or toggle back to blank when double-clicked again.

2. I need to be able to use the Patients Menu at the top to archive labs that are completed. So, if I use the Patient menu and select Archive/Retrieve -> Archive Data...then it should select only those rows on the Current sheet with a checkmark marked under the Completed column and move the row to the Archived sheet. Obviously, I'd like to be able to retrieve these as well so they'd move back when retrieve is selected.

3. Finally, I need to create a dropdown list to on each row under the Test Ordered Column, so that I can click the dropdown and select from the labs that are entered on the Labs sheet.

I appreciate any assistance. thanks.