prabhakarpeje
New member
- Joined
- Oct 22, 2013
- Messages
- 7
- Reaction score
- 0
- Points
- 0
Hi
I am currently working in a hospital and i am thinking of preparing an excel file for pharmacy staff where a stock, inventory & bills would be maintained in a single file. i have a stock list and a bill format in a single sheet here i need a help for the following things:
1. In bill format i want to add a drug/material name using data validation list and then by using vlookup function i need automatically pull the rate from the stock list of the sideby specified drug/material name(added by data validation).
2. then i need to auto deduct the qty specified in bill format's qty column from the stock list of the stock qty column.
i have tried hard to make but was not successfull so i have attached the file for ur editing..!
Thanking you in advance for the help..!
View attachment pharmac.xlsx
I am currently working in a hospital and i am thinking of preparing an excel file for pharmacy staff where a stock, inventory & bills would be maintained in a single file. i have a stock list and a bill format in a single sheet here i need a help for the following things:
1. In bill format i want to add a drug/material name using data validation list and then by using vlookup function i need automatically pull the rate from the stock list of the sideby specified drug/material name(added by data validation).
2. then i need to auto deduct the qty specified in bill format's qty column from the stock list of the stock qty column.
i have tried hard to make but was not successfull so i have attached the file for ur editing..!
Thanking you in advance for the help..!
View attachment pharmac.xlsx