I have an excel sheet which contains orders with stock availability. You need to create a query which finds products with high not in stock volume and puts this information within the excel sheet.
See attached [url removed, login to view] for reference:
A - Query taken from 'Old' Worksheet
B - Option to select which lines to query (e.g. Line 4080 - 4117)
C - Finds all rows with 'Not in Stock' or 'Incompleted' in Column F
D - Finds the products highlighted red in Column E, regardless of size (e.g. AJ4-20(10) where 10 is the size) - When highlighted Red, it means the item is not stock.
This information queried should be put on a new worksheet within the Excel file. See [url removed, login to view]
Product - Which Product was found Not in Stock
Not in Stock - How many times found Not in Stock
Lines - Which rows on the 'Old' Worksheet is the product shown not in stock
The resulting information should order the products found Not in Stock the most at the top. (e.g. Products found not in stock 10 times should be higher then products found not in stock 8 times)
If you are confident you can create this for me please make your bid. If you can create it before you bid and show screenshots to show it in action, it is more likely I will select your bid as the winner immediately, price depending.
28 freelanceria on tarjonnut keskimäärin 59 $ tähän työhön
I am a VBA expert, I have very good experience with EXCEL VBA macros. I have completed many projects on GAF in EXCEL skill. I will provide quick & professional service.