I have existing Excel file, i have created the formulas on some cells, but there are some functions that I need help with:
1. Autofilter the rows on value changes.
2. Autorefresh the Pivot when values on the screen changes.
3. Formula in STOCK WARNING (cell F4), If Part Number (Cell H3) includes "Recheck", then criteria is: N5<J5;"STOCK NOT ENOUGH";)
Formula in STOCK WARNING (cell F4), If Part Number (Cell H3) has other values, then criteria is: K5<J5;"STOCK NOT ENOUGH";)
4. Make an Export Button that will copy the active values in another sheet. on its format and export that sheet to a new xls file.
5. Make a sheet that will act like a form, it will show data from the Input sheet.
29 freelance font une offre moyenne de €25 pour ce travail
Hi there. Regarding your needs on your excel file, as being one of the highest rated Excel & VBA expert in this platform, I can work on your job. I am mostly online. Lets discuss more on chat.
Hi, I can do it. I can either give you refresh buttons or let the system do it by its own. The second program will be longer though and would take 3 days.