Find Jobs
Hire Freelancers

build the macro vb codes and formulas for my excel file.

€8-30 EUR

Completed
Posted over 7 years ago

€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 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 VBA. I have also a strong database and analytic background that could be a profit in your project. I've successfuly completed many Excel projects for random clients. Always on time and budget. What is your favorite way to comunicate? Ps. This could be one of my firsts projects on Freelancer.com, so give me the chance to proof that i'm realy good business partner.
€10 EUR in 1 day
4.9 (17 reviews)
4.5
4.5
28 freelancers are bidding on average €25 EUR for this job
User Avatar
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 out with that what you need so, if you are interested just text me thanks & regards
€34 EUR in 1 day
5.0 (204 reviews)
8.2
8.2
User Avatar
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 your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
€30 EUR in 1 day
4.9 (242 reviews)
7.5
7.5
User Avatar
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.
€30 EUR in 1 day
4.9 (342 reviews)
7.4
7.4
User Avatar
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.
€43 EUR in 2 days
5.0 (142 reviews)
7.2
7.2
User Avatar
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 regards
€40 EUR in 4 days
4.9 (242 reviews)
6.9
6.9
User Avatar
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. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
€30 EUR in 1 day
4.9 (126 reviews)
6.3
6.3
User Avatar
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 Programming, Developing System for Management and Creating Reports. I have also expertise in Creating User Form, Command Button, Drop Down, Radio Buttons, List Boxes etc. in excel VBA. I have done mostly this type of job where data manipulation is required. Please check my portfolio to see my work. So, I can do this job nicely. Ready to start please reply soon. Thanks, Virendra
€30 EUR in 3 days
4.8 (86 reviews)
5.7
5.7
User Avatar
Hi, I am interested to work with you. Please contact me on chat, I am waiting for your response. Thanks Sajib.............................
€24 EUR in 1 day
5.0 (65 reviews)
5.6
5.6
User Avatar
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
€15 EUR in 1 day
4.8 (34 reviews)
5.6
5.6
User Avatar
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 with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. I have great experience in any kind of data manipulation with Excel/VBA. I can start working on the project immediately and complete the job within one, maybe two days. If you send me a sample file and a job specification, I'm ready to create a free draft pilot for you. Regards
€19 EUR in 1 day
4.9 (63 reviews)
5.7
5.7
User Avatar
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. thanks john
€24 EUR in 1 day
5.0 (7 reviews)
3.8
3.8
User Avatar
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, dashboard, functions and formulas. About Myself Good Day!. Let me introduce myself for building your confidence in me. Worked at Sr. position with experience of marketing, Service, Production and IT Excel Expert Group Member Access Expert Group Member Proficient in Google Sheet Worked on Macro, VB, Pivot, User Form, Google Sheets Proficiency in Office tools, SAP, AutoCAD, 3DMax, Coral, Qualification- Mechanical Engineer Available on Skype Some Projects: Developed complete ERP system for Marketing in DB4 (earlier to Access) SAP implementation as Key Coordinator Community Survey (Near 10 Million Data compilation) in Excel Industrial Project Report in Excel Multilingual Kazien Sheet in Excel with VB Offer Preparation in Access Project Planner in Excel Very Large Database Analysis Completed few Contests at Freelancer For Details of my Work 1. Please see my profile 2. Please see Services offered by me. If you initiate dialog, I can submit samples of my work. It will be pleasure working for you. I believe in Customer Delight.
€30 EUR in 2 days
3.9 (9 reviews)
3.5
3.5
User Avatar
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 you. To know more about me you can check my profile & reviews. Thanks,Sathish
€11 EUR in 0 day
4.1 (8 reviews)
3.1
3.1
User Avatar
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.
€35 EUR in 2 days
5.0 (1 review)
1.7
1.7
User Avatar
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 done your task on the time. Thank you,
€8 EUR in 3 days
5.0 (1 review)
1.5
1.5
User Avatar
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
€10 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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.
€25 EUR in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Sir I can do this work please contact me here on freelancer website for further concern. I have really good experience as Data entry operator also have 3 people team working on freelancer, this is my new ID. Thanks Regards, Nimbus Admin.
€18 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
€29 EUR in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of GERMANY
Kiel, Germany
5.0
21
Payment method verified
Member since Jul 9, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.