W Toku

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.

Umiejętności: PHP, Architektura oprogramowania

Zobacz więcej: 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

O pracodawcy:
( 1 ocena ) India

Numer ID Projektu: #11749687

Przyznane użytkownikowi:

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] Więcej

₹3888 INR w ciągu 5 dni
(0 Ocen)
0.0

14 freelancerów złożyło ofertę na średnią kwotę w wysokości ₹5535 do tego projektu.

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 w ciągu 3 dni
(10 Ocen)
3.3
₹2250 INR w ciągu 3 dni
(9 Ocen)
3.2
₹7777 INR w ciągu 3 dni
(1 Ocena)
2.2
₹7777 INR w ciągu 3 dni
(0 Ocen)
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 Więcej

₹7777 INR w ciągu 3 dni
(0 Ocen)
0.0
keiksur3

A proposal has not yet been provided

₹11111 INR w ciągu 30 dni
(0 Ocen)
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 w ciągu 2 dni
(0 Ocen)
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 Więcej

₹8888 INR w ciągu 6 dni
(0 Ocen)
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 Więcej

₹7777 INR w ciągu 3 dni
(0 Ocen)
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 w ciągu 3 dni
(0 Ocen)
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 Więcej

₹7777 INR w ciągu 5 dni
(0 Ocen)
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 w ciągu 3 dni
(0 Ocen)
0.0
vw6490093vw

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

₹3889 INR w ciągu 3 dni
(0 Ocen)
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 Więcej

₹3333 INR w ciągu 1 dnia
(0 Ocen)
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 w ciągu 3 dni
(0 Ocen)
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 w ciągu 2 dni
(0 Ocen)
0.0