build the macro vb codes and formulas for my excel file.
€8-30 EUR
Paid on delivery
I have existing Excel file, i have created the formulas on some cells, but there are some functions that I need help with:
INPUT sheet
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.
Print Sheet
5. Make a sheet that will act like a form, it will show data from the Input sheet.
Project ID: #12627593
About the project
28 freelancers are bidding on average €25 for this job
Hello, I am excel expert and VBA programmer I have done very similar project to yours recently (client wanted using few criterias to fitler huge data copy in new file and print - handled in 2 hour) I can help you o More
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
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.
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega More
Hi, Experienced Excel VBA and VB.Net Programmer. I have read your instructions carefully. I have excellent knowledge and experience of Manipulating Data from Multiple Sheets, Advanced Formulas, Critical Progr More
Hi, I am interested to work with you. Please contact me on chat, I am waiting for your response. Thanks Sajib.............................
I have been involved in excel for the past three years. Very well versed on macros and have done freelance jobs related to VBA and macros. Looking forward to your reply
Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have opportunity to consult details More
hey - I've a lot of experience with VBA and Excel and I've also worked as a developer in the financial services industry for over a decade - happy to discuss your project in the chat window if you like my profile. than More
Evidently you need auto operative type macro. This box has limited space and no provision for attachments. I am Mechanical Engineer, proficient in MS Access, Excel Macro, Pivot Table/charts with slicer, dashboar More
Hi, Thanks for showing your interest to read my bid. About your project: I guess this task can be done in hour. if you could send me the sample file i will make changes as per your requirements and send it back to More
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.
Hello I am a programmer. It is available both Visual Basic and delphi. I have some work, in an Excel spreadsheet. We aim to serve you with quality and commitment to accuracy. i will use formulas of excel and i will don More
no need to pay me unliss all job is done I have more than 8 years experience in IT field, Microsoft servers, Exchange server, firewalls, networking, Symantec backup, system administration, DNS, DHCP
Hi i am Insan Ramadhan, i am used to work with excel and macro VBA everyday. You can count on me to work on your report, i will try my best to deliver the task.