Make a Excel Macro to validate information on a xls file
$30-250 USD
Pagado a la entrega
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!
Nº del proyecto: #8184983
Sobre el proyecto
Adjudicado a:
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, Más
39 freelancers están ofertando un promedio de $87 por este trabajo
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
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 rig Más
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. Más
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 d Más
Hello, I have a greate experience with VBA macro and data processing. I can to do this work good and fast!
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 va Más
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 technolog Más
"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
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 wr Más
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 descr Más
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 Más