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.

Wow! That's pretty awesome. The Patients menu doesn't appear to be working correctly anymore, though. Not letting me add patients correctly. Any ideas ? I just realized the Archive sheet doesn't have all the same columns as the Current sheet. I don't know if that makes a difference, but it's not moving all the checkmarks over and it screws up when I retrieve it back. I think a column to tick to move back would be fine as you suggested.

to the top

to the top