Make a Excel Macro to validate information on a xls file

Completado Publicado Jul 31, 2015 Pagado a la entrega
Completado 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!

Excel Microsoft Office

Nº del proyecto: #8184983

Sobre el proyecto

39 propuestas Proyecto remoto Activo Aug 3, 2015

Adjudicado a:

nagyzoltan68

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

$35 USD en 3 días
(109 comentarios)
6.1

39 freelancers están ofertando un promedio de $87 por este trabajo

maverick44000

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 en 2 días
(70 comentarios)
7.1
prameswara

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

$30 USD en 1 día
(301 comentarios)
6.9
elqueabandona

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

$194 USD en 5 días
(188 comentarios)
6.7
paris2785

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 Más

$90 USD en 3 días
(130 comentarios)
6.6
bdoutsource

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

$77 USD en 2 días
(96 comentarios)
6.0
masud0012

A proposal has not yet been provided

$55 USD en 3 días
(108 comentarios)
6.0
kevivu

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-engineerin Más

$35 USD en 3 días
(72 comentarios)
5.8
sergpooh

Hello, I have a greate experience with VBA macro and data processing. I can to do this work good and fast!

$49 USD en 3 días
(42 comentarios)
5.5
sumeet00

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 Más

$55 USD en 0 días
(7 comentarios)
5.2
dviruki

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 Fre Más

$58 USD en 2 días
(65 comentarios)
5.4
abhinovpankaj

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

$77 USD en 3 días
(40 comentarios)
5.2
carlosperezit

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

$55 USD en 2 días
(25 comentarios)
4.8
surekash7096

"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 en 2 días
(66 comentarios)
5.2
serdaryalcin

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

$83 USD en 2 días
(21 comentarios)
4.5
JITINGOYAL1992

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

$55 USD en 2 días
(24 comentarios)
4.6
gr8tech

A proposal has not yet been provided

$56 USD en 2 días
(30 comentarios)
4.2
shivaparvathi108

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

$30 USD en 0 días
(31 comentarios)
4.2
seanlave

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 cr Más

$77 USD en 4 días
(1 comentario)
3.0
ifaisal

hello. i can do this for you.i have done many similar projects. please see my feedbacks.

$55 USD en 2 días
(2 comentarios)
2.9
jgharris93

uh, i love macros and excel files. i can knock this out. give me a shot!

$96 USD en 2 días
(1 comentario)
2.6