Simple excel vba macro
- or -
Post a project like this2043
$
- Posted:
- Proposals: 3
- Remote
- #2128519
- Awarded
Description
Experience Level: Entry
For my sales business, I get a daily backorders sheet - I want to make the ordering process a lot easier. All the information is in 1 excel file but in multiple sheets.
Wanted result: 1 sheet with the products needed:
Artikelnummer | Artikel | Aantal | Leverancier
Translated: SKU | NAME | AMOUNT | SUPPLIER
2. the (sum) amount of 'products ordered but not yet received' should be added to the backorder amount (backorder sheet column G)
3. Only if the amount is still negative it should be in the 'need to order' sheet
4. Delete the minus ( - )
5 sort alphabetical by SUPPLIER and secondly alphabetical by Artikelnummer (SKU)
Thanks in advance!
Johan
Wanted result: 1 sheet with the products needed:
Artikelnummer | Artikel | Aantal | Leverancier
Translated: SKU | NAME | AMOUNT | SUPPLIER
2. the (sum) amount of 'products ordered but not yet received' should be added to the backorder amount (backorder sheet column G)
3. Only if the amount is still negative it should be in the 'need to order' sheet
4. Delete the minus ( - )
5 sort alphabetical by SUPPLIER and secondly alphabetical by Artikelnummer (SKU)
Thanks in advance!
Johan
Johan U.
100% (6)Projects Completed
5
Freelancers worked with
2
Projects awarded
33%
Last project
10 Jun 2023
Netherlands
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