Find Jobs
Hire Freelancers

Make a Excel Macro to validate information on a xls file

$30-250 USD

Completed
Posted over 8 years ago

$30-250 USD

Paid on delivery
Hello, Freelancers! We have a XLS file that contain some columns to be filled by users. We will make this XLS file available on our website and users will download it, fill it and re-send to us. But before re-send, we want our user to validate what was filled by him, to avoid problems. So we thought about creating a Macro or something on this Excel file that the user himself can execute and check what is wrong. Each column have its own rules, that I have specified on line 11 and 12. We should also lock lines 1, 2 and 3 so user dont change data on those lines. The button to run the Macro is on cell F1. By clicking on that button, Macro will check each cell filled, and check if it is following that cell rule. Users might add a lot of lines, so we should repeat the same check for each line added. I still dont know how we can show feedback about inputed data wrong, and we can discuss about it. I am also attaching an example of the file so you can check it before we talk. If you have read this text untill here, please type "uh, I love Macros and Excel files!" on your bid, so I know you have read everything. I will not consider your bid if you have not write it on the first line of your bid. Thanks!
Project ID: 8184983

About the project

39 proposals
Remote project
Active 9 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
uh, I love Macros and Excel files! Hello , I would like much to work on your project. I have great experience in excel macros / vba codes, I have already prepared the first 2 columns validation rules, as quality check, you can download from my dropbox here: " [login to view URL] ". I think it is a good idea that all error messages will be editable by you, so any time you can change them, or translate to other languages. You can find them at worksheet with name Messages. This worksheet will be hidden from user at the end. I am open to any new idea if you will have during this job, but I think it will work well as simply as is, with Message Boxes and redirecting the user to cell where the problem was found. Contact me please to discuss your opinion. Thank you.
$35 USD in 3 days
5.0 (109 reviews)
6.1
6.1
39 freelancers are bidding on average $87 USD for this job
User Avatar
Hi. uh, I love Macros and Excel files!. I am ready to begin working on the macro and I shall be able to finish within 2 days. Please discuss. Regards. Usman
$160 USD in 2 days
5.0 (70 reviews)
7.1
7.1
User Avatar
Hello Sir Im excel VBA macro and formula Expert :) i can do anything in excel like make macro to validate information like u want :) please give me a chance for doing your job and im able to start doing your job right now :) Thank You SIncerely Prameswara :)
$30 USD in 1 day
4.9 (301 reviews)
6.9
6.9
User Avatar
uh, I love Macros and Excel files!... 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. I was watching the file and all validations are possible, but some are rather more complex than others. And the number of rows is no problem. Best regards
$194 USD in 5 days
5.0 (188 reviews)
6.7
6.7
User Avatar
uh, I love Macros and Excel files! Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled 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).
$90 USD in 3 days
4.9 (130 reviews)
6.6
6.6
User Avatar
uh, I love Macros and Excel files! Dear sir, Greetings. We can assign some functions, set validation rules and other automation that necessary. Also, some VB coding could make it more effective. I'm skilled on doing this perfectly. Plz let me know if you are interested. Thank you. Sincerely, ahmsuza
$77 USD in 2 days
4.8 (96 reviews)
6.0
6.0
User Avatar
A proposal has not yet been provided
$55 USD in 3 days
4.9 (108 reviews)
6.0
6.0
User Avatar
Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Expert in MS office, which includes formatting, powerpoint presentation, mail merge, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers.
$35 USD in 3 days
4.8 (72 reviews)
5.8
5.8
User Avatar
Hello, I have a greate experience with VBA macro and data processing. I can to do this work good and fast!
$49 USD in 3 days
5.0 (42 reviews)
5.5
5.5
User Avatar
uh, I love Macros and Excel files! Hi, I have worked on multiple macro projects and performed data automation and validation tasks using VBA macros in office applications. Looking forward to quickly get this working. For user notifications, we can either have a pop up alert or cell based formatting to notify on errors, if any.
$55 USD in 0 day
5.0 (7 reviews)
5.2
5.2
User Avatar
uh, I love Macros and Excel files! Dear Sir/Madam, thank you for the detailed project description. I have 12 years of experience in data processing using Excel and VBA and I have completed a number of projects on Freelancer involving use VBA. I'd be glad to help you with this project. Please contact me to discuss project details (in particular, I'd like to know how you'd like to verify if data in column "Link para o Livro" is valid). Thank you!
$58 USD in 2 days
5.0 (65 reviews)
5.4
5.4
User Avatar
Hello, I have been working as freelancer since last ~ 2.5 years,prior to this was working with a MNC as an Sr. Software Professional. The project is Product based development and integration of the product with various already existing Products and processes.. Below are some key areas of my skills: -- VBA -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov
$77 USD in 3 days
4.9 (40 reviews)
5.2
5.2
User Avatar
uh, I love Macros and Excel files! Hi I'm an IT Project manager in a local bank with over than 20 years of experience in banking software development. Im an expert in .NET (c#, vb, c++), vba and sql server technologies. In my experience in banking i have made a lot of macros as the required. We use to add an initial column where we place an "*" when an error is found within a row. An excel comment with the errors details is attached to the cell. The macro runs until an empty cell is found in the first mandatory cell. Regards Carlos
$55 USD in 2 days
4.8 (25 reviews)
4.8
4.8
User Avatar
"uh, I love Macros and Excel files!" I have the expertise in scripting macros in Excel and do the task based on the description provided by you with accuracy. Ready to start work immediately
$111 USD in 2 days
4.5 (66 reviews)
5.2
5.2
User Avatar
uh, I love Macros and Excel files! If I am awarded, I will be creating the required macro. The macro will check the conditions, and in case there isn't any problem it will give an OK Messagebox If not it will write what is wrong in a messagebox. By the way will we be checking a single row, or all rows till we reach an empty row?
$83 USD in 2 days
5.0 (21 reviews)
4.5
4.5
User Avatar
Uh I love Macro and Excel files. I am a Chartered Accountancy student based in India. I provide an array of services relating to MS Office with Excel and Word being my area of expertise. Looking at the project description I am confident that I can execute this easily once I get to know the details. Looking forward for your response.
$55 USD in 2 days
4.8 (24 reviews)
4.6
4.6
User Avatar
A proposal has not yet been provided
$56 USD in 2 days
5.0 (30 reviews)
4.2
4.2
User Avatar
Hi, I have more experience in these kind of projects. It's very easy job for me. I have 5 years of experience in MS excel. 3 years of experience in VBA. Proper QC will be there before delivery. Please let me know when shall I start work with you on this.
$30 USD in 0 day
4.6 (31 reviews)
4.2
4.2
User Avatar
uh, I love Macros and Excel files! I've already completed the validation for the first column of ISBN numbers and can send you the file if you message me. Hello! I am extremely experienced in creating Macros to create usefully interactive tools for businesses. I've already taken a look at your file and can have this completed by Sunday evening at the latest. As far as feedback to users I can have a message tell them "There is an error in the red highlighted block!" and then highlight the incorrect block red. I can also have the message box tell them the type of error as well. Once the error is corrected the cell will turn white. Sean
$77 USD in 4 days
5.0 (1 review)
3.0
3.0
User Avatar
hello. i can do this for you.i have done many similar projects. please see my feedbacks.
$55 USD in 2 days
5.0 (2 reviews)
2.9
2.9
User Avatar
uh, i love macros and excel files. i can knock this out. give me a shot!
$96 USD in 2 days
5.0 (1 review)
2.6
2.6

About the client

Flag of BRAZIL
Sao Paulo, Brazil
5.0
57
Payment method verified
Member since Nov 27, 2012

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.