Encerrado

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, Processamento de dados, Processamento de Dados

Veja mais: 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

Acerca do Empregador:
( 0 comentários ) Mumbai, India

ID do Projeto: #27391727

9 freelancers are bidding on average ₹883 for this job

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 Mais

₹1500 INR in 7 dias
(1 Comentário)
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 in 7 dias
(0 Comentários)
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 Mais

₹1050 INR in 7 dias
(0 Comentários)
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 in 7 dias
(0 Comentários)
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 in 2 dias
(0 Comentários)
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 in 40 dias
(0 Comentários)
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 Mais

₹600 INR in 7 dias
(0 Comentários)
0.0
(0 Comentários)
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 em 1 dia
(0 Comentários)
0.0