need help designing or finding ms excel macros or templates that will help group of volunteers that aid the sick and elderly

Posted on 2014-01-27
Medium Priority
Last Modified: 2014-02-10
We have a group of volunteers that help sick and elderly in community. Can I get guidence on building ms excel app that a dispatcher could select from a list of services the patient needs. And have excel locate the apropriate volunteer based on his skill or particular service and location and send him the patients pertinent details so the volunteer can begin helping him.
Question by:Dov_B
LVL 35

Assisted Solution

by:Rob Henson
Rob Henson earned 700 total points
ID: 39811720
Looks like you need an Access database rather than excel.

MS Website has numerous templates for Excel and Access and am sure that there would be one for Skill Resource management.

Rob H
LVL 23

Accepted Solution

Danny Child earned 1300 total points
ID: 39811803
I'd suggest a table with Filters set as the most straightforward option, but if the list of services is complex, then you're going to need a database, as suggested.


Alternatively, using dropdowns could work as well
but they don't work as well if you want multiple options, like services.

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Over time, the online landscape has altered considerably, but that’s nothing compared to the up-and-coming trends that will shape the web design industry in the coming year. Keep reading to find out which trends will shape B2B web design in 2018.
Manually copying shapes and their assigned macros one by one to a new location can be tedious, but if you use the Excel utility workbook attached to this article, the process will be much quicker and easier.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

619 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question