En curso

Write some Software

Need to write an excel macro for complete validation of all fields for the data in a sheet.

Pls check the attached sheet. If you see few of the individual fields they have separate data validators ( You need the password to check the individual field validations - pls ping me for details).

I want this validation to be done for all the rows in case some one cuts and pastes multiple rows of data.

I want this validation to be triggered on clicking a validate button somewhere in the sheet

The fields withe validation are as follows : Email, Location, Phone, Qualification, Competency, Primary & Secondary skill, Industry, Project Exp,TE years, TE Months, RE Months, Aval_From

You can highlight the errors by marking the cell in red. Once the sheet is validated you need to set value as 'Validated : Yes' in another cell in a separate column. Once the sheet is edited again you can set the value back to 'Validated:No'

I also want you the check for Mandatory fields. All fields highlighted in red are Mandatory - you need to highlight the relevant cells and set the "Validated:Yes" field only if all fields are filled in.

I also want the 'Validate' button to be placed in the blue area on top besides the logo.

Habilidades: PHP, Arquitectura de software

Ver más: software write mq4, software write chip epson, useful software write book, status message paste complete vba excel macro, software write web specs, write bitmap data, write abstract data types, personal data sheet software developer, free software write user guide, software write edid, write update data script access table, write xml data file using excel vba, free software write company profile, software write websites idea, write mysql data base joomla, software write book images, mql4 write history data problem, perl script write form data mysql database, software write books, software write protection, free software write book, software write book, read xml files write fields, write normalization data, software write protect software

Información del empleador:
( 1 comentario ) India

ID de proyecto: #11749687

Adjudicado a:

ksinghrajeev

Hello There, I have done many complex work using excel formula, vba and access. You can check the below link. Project Report Automation - [url removed, login to view] Más

₹3888 INR en 5 días
(0 comentarios)
0.0

14 los freelancers están ofertando un promedio de ₹5535 para este trabajo.

furqan463

Hi! I'm very good at writing Excel macros, I will do your project according to terms and conditions we agreed upon

₹3500 INR en 3 días
(10 comentarios)
3.3
₹2250 INR en 3 días
(9 comentarios)
3.2
₹7777 INR en 3 días
(1 comentario)
2.2
₹7777 INR en 3 días
(0 comentarios)
0.0
janissacamacho

I provide a range of consulting, secretarial, and administrative tasks for a variety of clients. I assist with correspondence management (letters, email, reports, presentations), social media networking (I can recommen Más

₹7777 INR en 3 días
(0 comentarios)
0.0
keiksur3

A proposal has not yet been provided

₹11111 INR en 30 días
(0 comentarios)
0.0
mks201994

Dear customer, I have good skills in typing. I can finish your project in low cost within the specified time. so I request u handle the project to me. Waiting for your reply

₹1750 INR en 2 días
(0 comentarios)
0.0
kunalrout

I have experience in handling Data validation requirement for my clients. I have experience in Advance Excel functions and have a good knowledge in excel VBA (Macro). I have helped multiple clients in their automation Más

₹8888 INR en 6 días
(0 comentarios)
0.0
desmag1

ï'm a full time freelancer with years of experience in engineering and article writing, I have my Bachelor Degree in Electrical and Electronics Engineering. Knowledge Pro is dedicated to br Más

₹7777 INR en 3 días
(0 comentarios)
0.0
usman43able

data entry, excel work and for other related works, we can discuss the open positions in more detail, and you can ask any questions you may have

₹7777 INR en 3 días
(0 comentarios)
0.0
cefer41

Hi, I have experience with data processing, I can write a macro to check and validate all data in your workbook or if you want also I can Develop an a simple application when you drag and drop the excel file and report Más

₹7777 INR en 5 días
(0 comentarios)
0.0
DEVILEO750

i am good in excel and i also have a certificate of advance excel that means i am good in macro and data validation

₹5555 INR en 3 días
(0 comentarios)
0.0
vw6490093vw

i am good at excel macros and will do it for you.

₹3889 INR en 3 días
(0 comentarios)
0.0
marcosarocha

Hi, I have a great experience in Excel and macros development and i am a fast typist. I constructed my experience working at Yamaha do Brasil and DuPont do Brasil for 8 years, where i performed many gerencial report Más

₹3333 INR en 1 día
(0 comentarios)
0.0
patelchintan3112

I am a experienced python programmer. I can design a nice script to validate whatever data you want and display the errors on a dialouge box as well as in excel or in any form you want

₹3333 INR en 3 días
(0 comentarios)
0.0
caytifi

Lot of experience in excel, VBA and a lot of free time! Hope you choose me. Waiting for a contact. Thanks & Regards!

₹4444 INR en 2 días
(0 comentarios)
0.0