Cerrado

Excel data validation

I have an MS excel which is to be uploaded to a software. In excel there are around 65 columns.

User will copy paste data in this excel from other excel or systems.

Requirment -

[login to view URL] upload conditional formatting which will highlight cells which do not fits validation criteria so as to give warning.

2. It should allow copy paste from other excel

3 It should be user freindly

4. Open to macro

Each column has different validation condition

for eg

1. Text Fields - Max or Min length

2. Number fields - Max Amount/Min Amount. with restriction on 2 decimal

3. Date fields - Restriction only on future date or only on past dates or dates older than 2 months

4. Drop down fields - Data should be one of that of drop down

5. Conditional Field - Few fields would be mandatory/optional based on value on other columns

6. etc

Habilidades: Excel, Visual Basic, Procesamiento de datos, Entrada de datos

Ver más: excel data validation list, excel data validation dynamic list, excel data validation list named range, excel data validation formula if statement, excel data validation custom multiple criteria, excel data validation list and custom formula, excel data validation list from table, data validation examples, excel data validation empty cell 2007, excel copy paste date format different, data validation list closed workbook excel, excel data validation extraction, vba excel data validation worksheet, data validation excel file, qtp excel files data validation, qtp excel data validation, data validation vlookup excel, data validation qtp data excel, excel data validation picture, data validation list vba excel

Información del empleador:
( 0 comentarios ) Mumbai, India

Nº del proyecto: #27391727

9 freelancers están ofertando el promedio de ₹883 para este trabajo

sscbe

Hi, I can do this project for you. I am very good at Excel, Word Data copying, Data entry etc,. I can also create excel tracker sheet using formulae.. I have more than 30 years experience. I went through you excel shee Más

₹1500 INR en 7 días
(1 comentario)
1.0
blyuv

hey im interested to work for you i can do any data entry job you need im available any day of the week

₹1050 INR en 7 días
(0 comentarios)
0.0
shaziagulzar

Hi lient i am intersted for your work in flexible hours and work honestly. i am student of virtual university of pakistan master of computer scienceplease if your are awared project my demand less cost because this Más

₹1050 INR en 7 días
(0 comentarios)
0.0
shivbalak209121

Hello Sir, I read through the job details extremely carefully and I am absolutely sure that I can do the project very well.I am a student

₹750 INR en 7 días
(0 comentarios)
0.0
rohitpatil4290

Hii. I am professionally masters in computer excle. you can give me this work I will give you my 100% of my work.

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

I am feel answer in interested data entry I am interested your project main aapka work bahut hi kam time per aur acche se accha kar sakta hun I am waiting your project only one one chance please I am request MI

₹800 INR en 40 días
(0 comentarios)
0.0
sAyEEdXP

Hello there, I'm Sayeed and I'd like to take this job because I've been doing this kind of stuff in Fiverr for over 3 years now. I'm new on this platform but I'm a worthy person to take this kind of job for a long term Más

₹600 INR en 7 días
(0 comentarios)
0.0
(0 comentarios)
0.0
igsureshkarthik

Hi Team.. I have an experience of 10 years in macro creation. Automated most of the Excel day to day work. Kindly give me a opportunity...

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