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.
Login to your account and send a proposal now to get this project.Log in
Clarification 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 2023
I 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.