I need help with VBA excel
- or -
Post a project like this3448
$50
- Posted:
- Proposals: 4
- Remote
- #445884
- Awarded
Description
Experience Level: Intermediate
Hi,
I am very new to VBA, but i believe that vba will help me in to keep track of my items. However i met up with some problems. Thus i hope you are able to help me out.
Problems that i face:
1.The cargo Box can only store 30 items whereas the refrigerator can store up to 50 items.
2. Items that come in are very random and can have up to 30 items each day.
3. Special items need to store at special location.
4. This list is shared between friends thus can be be very difficult to maintain the same quality of work. thus is there any method to ask the personnel to log in this file via username or pw?
5 i also need to keep track of how many same product came in from the same supplier.
I manage to solve the storage location by using countif function and a if function, like if the items in cargo box is item 61, it will be at cargo box 3.
i believe that VBA in excel should be able to help me, but i really got not enough time to explore.I need a good way or any method to solve all my problems above. I also know that i am kind of asking for too much, but i am sort of desperate already as my items keep piling up and is super messy. Urgent help is really needed. thus i really appreciate your response so much.
Thanks and Regards
I am very new to VBA, but i believe that vba will help me in to keep track of my items. However i met up with some problems. Thus i hope you are able to help me out.
Problems that i face:
1.The cargo Box can only store 30 items whereas the refrigerator can store up to 50 items.
2. Items that come in are very random and can have up to 30 items each day.
3. Special items need to store at special location.
4. This list is shared between friends thus can be be very difficult to maintain the same quality of work. thus is there any method to ask the personnel to log in this file via username or pw?
5 i also need to keep track of how many same product came in from the same supplier.
I manage to solve the storage location by using countif function and a if function, like if the items in cargo box is item 61, it will be at cargo box 3.
i believe that VBA in excel should be able to help me, but i really got not enough time to explore.I need a good way or any method to solve all my problems above. I also know that i am kind of asking for too much, but i am sort of desperate already as my items keep piling up and is super messy. Urgent help is really needed. thus i really appreciate your response so much.
Thanks and Regards

Brendan C.
100% (2)Projects Completed
3
Freelancers worked with
1
Projects awarded
100%
Last project
9 May 2015
Singapore
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies