User Profile
poje12
Copper Contributor
Joined Jul 24, 2023
User Widgets
Recent Discussions
Re: File for work. please help!
each item has it's own unique code. don't really understand what you mean. the code is on the package of the item and it's the only way for me and the company to know which item are we talking about. the stock item is a finite one. occasionally we had new items. every new item has it's own code. the company that sterilised them give us a new code for every new item.Re: File for work. please help!
Hi Mathetes, Thank you for your reply. Sorry I'm not very good with it. I attached the file. I work in a hospital and i have a list of items that we use for dental reason that we have to sterilise after every use. In the first page there is the list of items, I check every morning what is dirty and need to be send to the sterilisation. Since it's an external company that does that, I have to keep track of what i send and when. They often lost items, or didn't send them back on time. The turn around should be 24 hours but sometimes I have to send out new items even if the others are not back. When i send the items i change their status (out/off), then i select the items that have that status and i copy them on the other page, next to the date. When they come back i change their status back and highlights them on the page with the date. I do this almost every morning, manually. My problem is that since it's a long process, when i'm off no one does that. I would like to make it more automatic. Hope you can help! thanksFile for work. please help!
Hi all, i have a file that i use for work. Right now there are 2 different pages. a list of the items with their code and an info about their situation. For Example if they are out, lost, etc. a list of numbers that i send next to the date. if they come back they are yellow, if not they are red. i do all of this manually every day, but when i am not in the office no one does that because it's long, boring and probably very confusing. Ideally i need something that keeps track of what goes out and what comes back and the dates. i attached the two pages. any help, advice, would be highly appreciated!! Many thanks!
