Create an excel Macro using VBA to automate a piece of work
- or -
Post a project like this1913
£75(approx. $94)
- Posted:
- Proposals: 24
- Remote
- #2272754
- Awarded
Transcription, PDF conversion, PDF form filling, PDF editing, ADOBE ACROBAT, Data entry, QC Analyst, Testing, Captioning
Pune
Spreadsheets|Excel macros and VBA|Google sheets |Google app scripts|Presentations - Tableau, PowerPoint, Prezi|Google data studio
Bay Minette
36527512852702522480250755824785852423185241027422630581792694164249214494731371827
Description
Experience Level: Expert
Estimated project duration: 1 - 2 weeks
Hope you’re well.
Im looking for someone to help me create an automated system to show the status of each item I buy for my company.
To give you some background, I work for supply chain and we buy various products (approx. 2000 items per month) and I am in charge of giving a status to each of the items to management. Currently I extract an excel report from PRIMAVERA which lists all our items (incl. price, qtd, description,ect). I then create a STATUS column where I manually give a status to each item (currently approx. 10,000 items). The report has to be shared every week and its exhausting having to do repeated work. Each item can change up to 3 times in a week.
Is this something you can help me with?
Im looking for someone to help me create an automated system to show the status of each item I buy for my company.
To give you some background, I work for supply chain and we buy various products (approx. 2000 items per month) and I am in charge of giving a status to each of the items to management. Currently I extract an excel report from PRIMAVERA which lists all our items (incl. price, qtd, description,ect). I then create a STATUS column where I manually give a status to each item (currently approx. 10,000 items). The report has to be shared every week and its exhausting having to do repeated work. Each item can change up to 3 times in a week.
Is this something you can help me with?
Paulo P.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
50%
Last project
3 Feb 2019
Angola
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Paulo,
Be delighted to help you, but not clear what you write in the "Status" column? (e.g. Total of that item ordered but not yet received? Change in the item's stock level since the last report? Listing items where stocks are below their re-order level?) . And where do you obtain the "status" information you enter?
758775
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