Save Patient Records As Database System

Hi there,

I need some help.

I'm fairly new to excel, but I've been looking for a solution to this problem for a while and haven't found anything. hopefully someone can help:


I work in a pharmacy. when a patient needs medication, he/she will give me a list of the items and i must request them from the surgery. This happens ALOT. not only with different patients in a given day, but repeating patients over a month. And every time i request medication for a patient, i have to type up the patients details into an excel template we have:

Column A = Patient Name
Column B = Address
Column C = Surgery
Column D = No. of items

Patient Medication Requests.xlsx

As you will realise, the patients name, address and surgery will always remain the same. i.e. if Patient A comes in he will live at A and belong to surgery A
The only thing that will differ from time to time is the no. of items that patient is requesting.

every time i have to type up this patients request, i have to type up the persons name address and surgery which may have already been entered only a couple of days ago. and sometimes this patient will not write down his/her address or surgery on his/her request. Which leads me to my question:

Is there anyway to save patient A's details so that as I'm typing his name into column A, column B and C will autofill with his/her other details.

Its essentially a patient record. And sort of a database system. A database of all the patients with their personal record containing name, address and surgery.

I have for the past year been repeating this same method day in day out. Its tiresome. Please can someone help me. I would be extremely grateful.

Thanks and sorry for the essay.

Fai