Hi,
I'm a pharmacy student trying to set up a scan logging system. I have a barcodescanner, computer and label software.
I have a excelfile (database) with information about medicines, with all the information about the medicine in one row.
So like this:
aspirin| product code 12345| barcode 54321| white tablet | etc.
i want to make a logbook for workers here to be able to work in.
I want them to be able to scan a product with our barcode scanner (it scans and ''types'' the number and then presses enter).
After scanning i want the logbook to recognise the code and give an error if not recognised, but if its recognised i would want to have the file automatically enter all the data from the database in the logbook.
the ideal situation would be if the worker using this logbook would not be able to adjust anything except adding the expiracy date and batchnumber of the product, aswell as their initials.
so the output would be like this:
batchnumber | date| workerinitials| aspirin| product code 12345| barcode 54321| white tablet |
i already have made the database and i have a logbook with: IF() formula that gives me a ''barcode found''/'barcode not found' that works. Although i would like to add a red/green color indicator to this if possible.
I'm kinda struggling with making a formula that will paste the information out of the database in my logbook. I'm Using Vlookup but cant get the multiple colums to paste, same thing goes for when using index.
Can anybody help me in the right direction? should i use acces instead of excel by the way?
I'm a pharmacy student trying to set up a scan logging system. I have a barcodescanner, computer and label software.
I have a excelfile (database) with information about medicines, with all the information about the medicine in one row.
So like this:
aspirin| product code 12345| barcode 54321| white tablet | etc.
i want to make a logbook for workers here to be able to work in.
I want them to be able to scan a product with our barcode scanner (it scans and ''types'' the number and then presses enter).
After scanning i want the logbook to recognise the code and give an error if not recognised, but if its recognised i would want to have the file automatically enter all the data from the database in the logbook.
the ideal situation would be if the worker using this logbook would not be able to adjust anything except adding the expiracy date and batchnumber of the product, aswell as their initials.
so the output would be like this:
batchnumber | date| workerinitials| aspirin| product code 12345| barcode 54321| white tablet |
i already have made the database and i have a logbook with: IF() formula that gives me a ''barcode found''/'barcode not found' that works. Although i would like to add a red/green color indicator to this if possible.
I'm kinda struggling with making a formula that will paste the information out of the database in my logbook. I'm Using Vlookup but cant get the multiple colums to paste, same thing goes for when using index.
Can anybody help me in the right direction? should i use acces instead of excel by the way?