Post Project
  • Search
    • Buyers can
    • Search offers to buy now
    • Search freelancers to request a proposal
    • Freelancers can
    • Search projects to quote on
  • How it works
  • Log in
  • Sign up
  • Freelancer?
Browse by Category
    Technology & ProgrammingWriting & TranslationDesignDigital MarketingVideo, Photo & ImageBusinessMusic & AudioMarketing, Branding & SalesSocial Media

    I need help with VBA excel

    - or -

    Post a project like this
    3448
    $50
    • Posted: 10 years ago
    • Proposals: 4
    • Remote
    • #445884
    • Awarded
    Rundie D.
    Gary S.Manu J.Sreejith A. have already sent a proposal.
    • 0
    • 0

    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
    Brendan C.
    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 in

    Clarification Board Ask a Question

      There are no clarification messages.
    3448
    $50

    - or -

    Post a project like this
    Brendan C.
    Brendan C.
    100% (2)
    Projects Completed
    3
    Freelancers worked with
    1
    Projects awarded
    100%
    Last project
    9 May 2015
    Singapore

    Related project Searches


    VBA programming language

    Product

    • About
    • Team
    • Careers

    Support

    • How it works
    • Trust & Safety
    • Help Centre

    Discover

    • GuidesStoriesNews

    Resources

    • Customer Stories
    • Business Cost Calculator
    • Startup Cities

    Browse

    • Freelance Services
    • Freelance Services By Country
    • Freelance Skills
    • Terms
    • Privacy
    • Sitemap
    • Company Details
    • © 2023 People Per Hour Ltd
    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