Find Jobs
Hire Freelancers

Excel VBA Expert with Macros to ensure data validation before file saving is successful

$30-250 USD

Completed
Posted over 10 years ago

$30-250 USD

Paid on delivery
I have an Excel file. I need Excel VBA Expert with Macros developed to ensure data validation is done before file saving is successful. I need that at the point of users saving the file, there are Excel Macros in place, with VBA codes written, to ensure that certain validation rules are met (like for example, that if some columns have specific inputs, then some other specific columns cannot be left blank) , if not the file cannot be saved. This will make sure that whatever user is updating the file, he or she will not leave out certain columns blank when he saves the file. The validation rules are pretty straightforward. I have less than 10 validation rules, for about less than 10 Excel columns.
Project ID: 5298238

About the project

37 proposals
Remote project
Active 10 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
This does indeed sound very straightforward. I shouldn't take long to get that done. How are you doing the input? Making a form for data entry is often the way to go to ensure consistency. But it can of course be done so that when you hit save, it runs a macro. Hope to hear from you. I can have it done a few hours after you send the criteria.
$45 USD in 1 day
5.0 (1 review)
1.3
1.3
37 freelancers are bidding on average $92 USD for this job
User Avatar
Hi, My name is Jon and I am an expert in advanced Excel functions and macros. I will be happy to help you with this project and I'm confident that I can do this job quickly and effectively Looking forward to your response
$88 USD in 1 day
4.9 (126 reviews)
7.1
7.1
User Avatar
VB, VBA and Databases expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please check https://www.freelancer.gr/projects/Data-Processing-Excel/data-translation-excel.html and feedback at https://www.freelancer.gr/u/paris2785.html I can start right away. For any questions, please let me know. Paris
$30 USD in 1 day
4.9 (131 reviews)
7.0
7.0
User Avatar
Hi Shoguns. I have read the rules file that you just uploaded. I am quite an expert in Macros and Excel. I can do the validation checks for you to ensure data integrity. I have done many similar projects before requiring the same data format checks. Lets discuss and get started on it. Regards. Usman
$120 USD in 2 days
5.0 (58 reviews)
6.6
6.6
User Avatar
Hello, I have created a plethora of macros of any kind and difficulty level, as an Excel-VBA trainer for 12+ years, teaching all levels and as a VBA developer, including macros for data validation. This could be an easy project, finished in max 2 days, including all tests. Except of the validation rules, I need to know the Excel version(s) you want to use this macro from, and also how do you prefer this macro to be involved: as an Excel add-on, an automatic macro, a user selected macro from a list... Looking forward to hear from you, Kind regards, chriskerpini
$72 USD in 2 days
4.9 (57 reviews)
6.3
6.3
User Avatar
Hi, Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, MS Word etc.. I have more than 10 years of experience to my credit. I have also worked on advanced VB features like making of ActiveX Exe, ActiveX dlls, OCX, Win32 API, multi-threading etc.. I fully understand on this highly competitive site how important it is to provide high quality work. My prime focus is 100% customer satisfaction. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks & Regards FineCoder
$70 USD in 5 days
4.9 (94 reviews)
6.0
6.0
User Avatar
I am an expert in macros and willing to discuss further about the project specifications and details.
$147 USD in 3 days
4.9 (37 reviews)
5.6
5.6
User Avatar
Hello there, I'm a software engineer with more than 15 years experience in Excel, Access, VBA, VB6, .NET, SQL. I'm waiting for detailed project description. During our contract I will be available via Skype/Gtalk, email and via site message center. All of these messages are forwarded to my cell phone so you can rest assured communication will not be a problem. Bugs fixing and minor changes are included in the bid without any additional fees. Best regards, Adrian
$94 USD in 3 days
4.9 (16 reviews)
4.7
4.7
User Avatar
Hello I can develop the excel with validation form VBA code very well. I can start immediately. Regards Nikhil I have checked the attachment you can hire me to start
$120 USD in 3 days
4.8 (27 reviews)
4.9
4.9
User Avatar
Hello, If you will provide source file and check logic, this project can be finished within hours. Best Regards Giorgi
$50 USD in 1 day
4.9 (9 reviews)
4.6
4.6
User Avatar
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.
$111 USD in 3 days
4.4 (20 reviews)
4.6
4.6
User Avatar
Hello. My name is Shaun Ripplinger, business consultant, Excel guru, and admin of a popular Excel website. Given the project details thus far, I am fairly confident that I can develop an Excel macro that would automatically check the specified columns for the specified criteria prior to saving, however, prior to bid acceptance, please forward more specifics as to exactly what you would like done, as well as the necessary files to do so, so that I may get started early and offer you a preview of the quality of my work and further ensure we are on the same page as far as what is expected in the finished product and the time-frame for delivery of completed items. My credentials are listed below. BA - Business Administration - Accounting major, and approx. 14 years experience using Excel, including developing a variety of historical/proforma budgeting/forecasting/charting/graphing/pivot-table options, as well as a variety of VBA macros to automate tasks and analyze information From user entry pop-up windows, to looping through excessive data sets, making comparisons/calculations of dynamic and/or ever-changing data, copying/pasting, merging and providing formatting and/or graphical output based off of this analysis, I have the ability to program functions/formulas that go far beyond the basic capabilities of Excel. Please feel free to visit my freelancer.com profile page to get to know a bit more about me and/or view recent client reviews. Thank you for your consideration.
$110 USD in 3 days
5.0 (2 reviews)
3.5
3.5
User Avatar
Hi Webshoguns, The job is pretty easy for me. I will code your validations under the trigger event 'Workbook_BeforeSave' in the sheet, that's it :) Please send me the details and lets get started. Thanks, P
$45 USD in 2 days
5.0 (5 reviews)
2.9
2.9
User Avatar
PLEASE GIVE US A CHANCE TO SERVE U . WE SPECIALISE IN VBA AND WE CAN DELIVER U THE PRODUCT IN LESS THAN 24 HRS.
$55 USD in 1 day
5.0 (4 reviews)
2.8
2.8
User Avatar
I can customize a function that can validate this condition. I am a professional programmer with lots of experience in Excel VBA/ Macro. I'm just starting out here in freelancer.com so I'm bidding under simple jobs like this. I can assure you that I can get the job done. Let me know if you're interested. Thanks. God Bless.
$50 USD in 3 days
5.0 (4 reviews)
2.5
2.5
User Avatar
Hello Sir, I am an VBA expert I can do this job easily. I have lots of experience with VBA coding. . . .. . ..
$98 USD in 4 days
5.0 (2 reviews)
1.7
1.7
User Avatar
Hi, I have hands on experience in Excel VBA. More than 10 years of exp in this area. supported biz users in one of the top MNC company in Singapore to customise, validate and summarise the excel data using VBA. Handled huge amounts of data imported from other data sources validated and formatted to suit the end user requirements. Thanks & Regards PC Rao
$55 USD in 3 days
4.9 (4 reviews)
1.0
1.0
User Avatar
Dear Sir, We claim to get it done perfectly for you EXACTLY in the way you want it - Kindly give we a chance and we will prove myself - Ready to prove our words, let's get it done right away and I mean RIGHT AWAY !! Looking forward to hear from you soon - GOD Bless
$144 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Greetings we are ready for sample work After going through details We are ready to work on this project. Kindly contact me through PM. Eagerly waiting for your response Thank You
$111 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I will bring very strong Excel VBA Skills with over 19 years experience developing full featured Excel applications to bear on your project. I am available and ready to begin immediately.
$88 USD in 3 days
0.0 (1 review)
2.9
2.9
User Avatar
A proposal has not yet been provided
$35 USD in 0 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SINGAPORE
SINGAPORE, Singapore
4.7
203
Payment method verified
Member since Jul 7, 2008

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.