![phoenix](https://d1a29h5kxv3oc2.cloudfront.net/dist/img/phoenix.81914efc7207f6a059bd10f5d3fd5f89.png)
I have a spreadsheet that requires VBA automation
- or -
Post a project like this$30
- Posted:
- Proposals: 26
- Remote
- #4107232
- Expired
Experienced Full Stack Web and App Developer |Android and IOS App Development| Project Management
![#3 in Social Media #3 in Social Media](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/f4ec0a78855bf9dcf78cb1126bf0bd50.png)
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
️ Python Developer | Web & App Development | Creative Content Writer | Graphic Designer Expert
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
AUTOMATION EXPERT l VBA l PYTHON l SQL l POWER AUTOMATE l WINAUTO l DATA ANALYSIS l ACCESS
Excel and VBA expert. Professional OCR. PDF to Excel Conversion. Data management, Translations English Russian
Spreadsheets|Excel macros and VBA|Google sheets |Google app scripts|Presentations - Tableau, PowerPoint, Prezi|Google data studio
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
489978410189714122805017684031018423611046308888995960333714494331285450106352261642492
![Imran K.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/3d8e7ee3f1e66a86703cf3adcfc6906d_70x70.jpg)
![Asma G.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/5198fa6a065d494b4761910bbca64080_70x70.jpg)
![Mohammad Sadat Uddoula P.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/af9e335d81b32cb679c3dbcdbc8f2afb_70x70.png)
![Pradeep T.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/e53be17f43a116b4ab81e2e6c48eb2be_70x70.jpeg)
![Muhammad T.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/49da18424d3d37dc5e4e99fe6f145f7d_70x70.jpeg)
Description
Experience Level: Entry
I have a spreadsheet that requires automation. Can you help?
I have MS Excel document where it presently shows tabs for: the following types of items: headware, miscellaneous, parkas, shirts, DEU tunics, FTU tunics, DEU pants, FTU pants, DEU boots, FTU boots
On each tab, the headers are: inventory ID (its a number, mostly used for me to just reorder)., Name (title of the object for ordering), description (description of item), unit price (its based on a point system, not currency, and is presently ), quantity in stock, reorder level, and quantity to reorder.
When I update this sheet, I want to scream. There is too many items (809 to be exact )and simply removing an item from each section as required, is extremely time consuming.
I was thinking of making the sheet have another tab where you select "issue" or "return", type in the size and then it will auto removes or add it to each items count.
I would also need another tab bulk new inventory to be added in
(like 25 t-shirts, size small). But I have no idea how to do so.
![Brooke-Lynne C.](https://www.peopleperhour.com/imgs/default_avatar_light_70x70.png)
Brooke-Lynne C.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
0%
Last project
27 Jul 2024
Canada
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
do you use office on mobile? if yes, VBA is not compatible with mobile, it runs only on pc version.
Also, budget is a little low for this project..
thanksBrooke-Lynne C.09 Nov 2023I don’t use it on mobile, I use it on mac. I just took a screenshot on my phone for a quick glance for a visual
-
All that for £24? Such low budget repels qualified freelancers.
10801741080168
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