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.
Hey there, From the sounds of it, you need Excel expert who can write vba code, write optimized formulas and present data in a simple way. Is that sounds about right? I have an extensive knowledge of Excel included Plus
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.
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 Plus
Hello jeitaro, I have read your project description clearly and understood you requirement and agree that can complete task with high quality and [url removed, login to view] our reviews to confirm our work quality(100%completi Plus
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, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. Please send me more details so that I can estimate cost and time better. I have completed more than 300 projects. Plea Plus
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled (VBA) Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach y Plus
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 Plus
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 Plus
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 Plus
Hi, I am interested to work with you. Please contact me on chat, I am waiting for your response. Thanks Sajib.............................
Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. I assured that i have provide you 24/7 communication support during the projec Plus
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 Plus
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 Plus
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 Plus
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.