Annulé

Excel VBA Expert

I am looking for an Excel Expert for a long term project.

Here is a test question:

I have a sheet in Excel 2007 that contains 10 columns, each with data validation pointing to various lists in another sheet.

Users have access to this sheet to enter data manually. Often users copy and paste their cells or entire rows, e.g. data from one month (one of the columns) gets pasted into another row. In this case the data validation is overwritten, but still accurate as long as the copy and paste was from the same column.

However if a user wanted to overwrite and individual cell (because e.g. she was frustrated with data validation limitation), we loose the ability to find such violation of the data validation rules.

Question

1. In case an overwrite such as the latter occurs, how can we prevent int Excel 2007

2. If we can't prevent it, how can we flag it for the auditor (to show that the data is invalid)

Please let me know your ideas, to help me better asses your qualifications

1) Set up your data validation list , for each cell to fill

2) Protect the spreadsheet with allowed data entry option

3) Set up conditional formatting for each entry cells with the option "Use a formula to determine which cells to Form

4) Use this formula =not (+max ((D2=J3:J5)*1)) and put format to red

copy the name patata in the sheet2 and paste it in sheet 1 d2 , it turns red: If D2 = patata , then D2 turns to red because it is not contained in the validation list J3:J5 .

Compétences : Excel

en voir plus : wanted excel expert, test excel expert, looking for an excel expert, how to expert in excel, how can i expert in excel, find auditor, find an excel expert, expert in excel help, expert help with excel, excel test expert, excel form to enter data, excel expert up, excel data entry validation, excel data entry form 2007, data entry validation access, data entry in excel 2007, data entry in access 2007, data entry form access 2007, data entry and validation, auditor test

Concernant l'employeur :
( 0 commentaires ) Paris, France

Nº du projet : #7919296

12 freelance font une offre moyenne de $20/heure pour ce travail

Teloquence

Consider it done. Check my past reviews for your reference eagerly looking forward for your reply so that I can start with the implementation

$24 USD / heure
(281 Commentaires)
7.4
zExcel

A proposal has not yet been provided

$25 USD / heure
(178 Commentaires)
7.1
fhasanbd

A proposal has not yet been provided

$22 USD / heure
(106 Commentaires)
6.2
raghav1101

Hi, I would love to work on this project. I have 8 years of experience in Microsoft Excel including working with excel modeling, dashboards and macros. Okay, I see that you are looking to go for preventive (preventi Plus

$21 USD / heure
(49 Commentaires)
5.2
rajafaizan

Hello sir... I provide very fast work & guarantee you 100% satisfaction and my expertise lies in quality service and delivery on Time kindly if you wants high quality work then as soon as possible discuss me. Please gi Plus

$16 USD / heure
(17 Commentaires)
4.1
abhinovpankaj

Hello, I have been working with a MNC based company since last ~ 4 years, as an Sr. Software Professional. The project is Product based development and integration of the product with various already existing Prod Plus

$16 USD / heure
(11 Commentaires)
4.2
TonmoyRoy111

Sear Employer, I can accomplish the job for you. I have sound knowledge in excel And I have previously carried out a number of projects in excel using macros and formulas. Kindly contact me for further details. Than Plus

$22 USD / heure
(16 Commentaires)
3.1
citijayamala

Expert in Excel, Excel functions, VBA macros, pivot tables, charts, and expert in finance as well. I can work on the VBA as per your requirement. Jayamala from India Hire Me

$16 USD / heure
(11 Commentaires)
3.4
leelaaswanth

Will give you 100% accurate and efficient [login to view URL] you please ping me to discuss.......................................

$22 USD / heure
(10 Commentaires)
2.9
JeffLee21

Dear Sir, I'm very interested by your project. I am programmer with sincere and capable. I have developed many project. You can found good my projects in my work history. Particular, I have rich experien Plus

$15 USD / heure
(4 Commentaires)
1.9
BlueViSion7

Good day, My name is Nikola Nuspahic and I am business manager at BlueViSion IT Solutions. It is a team of web developing and market research experts from East Europe. Our expertise are Web Development, Database De Plus

$15 USD / heure
(0 Commentaires)
0.0
garvitbanga

Just say hard Work ................................................................................................................................................................................

$22 USD / heure
(0 Commentaires)
0.0