Hello all!
First forum post (hope this is in the right spot):
I work for a medical facility that dispenses many medications. We generate an Excel MAR sheet (linked) for each client. As we used multiple medications, it can be tedious to type out each individual order. We've been utilizing a copy-paste system, but its rather clunky and awkward, and not all employees are PC adept enough to do this efficiently. My desire is to create a script or formula that would link each medication to a checkbox, clicking the checkbox would result in the first blank box under "Medication order" being populated with that medication, another checkbox populating the next blank "Medication order" with another medication, etc. I'm quite computer savvy, but Excel is a weak spot for me. I've included example medication orders in rows 41-44, exemplifying medications I'd like to populate those fields. Any way to go about this? Thanks!
https://drive.google.com/file/d/1MOTCKPH0H7e0-9NjUm9j9eBWVhoebGa1/view
<colgroup><col><col><col><col><col span="31"></colgroup><tbody>
</tbody>
First forum post (hope this is in the right spot):
I work for a medical facility that dispenses many medications. We generate an Excel MAR sheet (linked) for each client. As we used multiple medications, it can be tedious to type out each individual order. We've been utilizing a copy-paste system, but its rather clunky and awkward, and not all employees are PC adept enough to do this efficiently. My desire is to create a script or formula that would link each medication to a checkbox, clicking the checkbox would result in the first blank box under "Medication order" being populated with that medication, another checkbox populating the next blank "Medication order" with another medication, etc. I'm quite computer savvy, but Excel is a weak spot for me. I've included example medication orders in rows 41-44, exemplifying medications I'd like to populate those fields. Any way to go about this? Thanks!
https://drive.google.com/file/d/1MOTCKPH0H7e0-9NjUm9j9eBWVhoebGa1/view
<colgroup><col><col><col><col><col span="31"></colgroup><tbody>
</tbody>
