Help needed with VBA / Macro's on a stock / inventory database
- or -
Post a project like this517
£50(approx. $63)
- Posted:
- Proposals: 10
- Remote
- #3733037
- Awarded
PPH TOP Website & App Developer✮LOGO & Graphic Designer✮Content Writer✮Translator
Dubai
Creative Graphics Designer & Full stack Developer| Shopify expert| Data entry |PDF Editing
Toronto
WordPress Expert/Woocommerce Expert/Data Scientist/Python Expert/Auto-CAD/3D/2D Animation/ White Board Animation
Rawalpindi
⭐ TOP RATED ⭐ Graphic Designer| WordPress / WIX |2D Animator| Video Editing |Photoshop Expert
Karachi
Designer and Developer|WordPress|Shopify|PSD|PHP HTML, JavaScript|WIX| PowerPoint/Keynote| Logo Designing
Berlin
Professional Digital Marketer | Web Development | IOS and Android Developer | WordPress | React Native | Video Editor | Graphic Designing
Islamabad
Quick Graphic Designer + Animator + Video Editor + Photo Editor + Logo Designer + Autocad Designer
Sydney
3873491164997122748043075310315100533061743811478545539464769066608173
Description
Experience Level: Entry
I have created a stock list & Inventory database, but have hit my limit in terms of my knowledge with VBA etc.
I have managed to get it set up so that when I add a part to a stock In & Out list it automatically goes onto the inventory, however I am trying to setup a button which when clicked, it minus's a number (set in Column E) from the total in Column D (which is in turn created using SUMIF). So the button will effectively need to edit the formula in Column D to minus 1 x column E on the first click, then 2 x Column E on the second click, 3 x on the third, so on and so forth.
Hopefully my rambling makes sense!
Spreadsheet is attached to the job, I'm sure it'll make more sense once you see it.
I have managed to get it set up so that when I add a part to a stock In & Out list it automatically goes onto the inventory, however I am trying to setup a button which when clicked, it minus's a number (set in Column E) from the total in Column D (which is in turn created using SUMIF). So the button will effectively need to edit the formula in Column D to minus 1 x column E on the first click, then 2 x Column E on the second click, 3 x on the third, so on and so forth.
Hopefully my rambling makes sense!
Spreadsheet is attached to the job, I'm sure it'll make more sense once you see it.
Projects Completed
17
Freelancers worked with
15
Projects awarded
59%
Last project
29 Mar 2024
United Kingdom
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