excel_1317
Board Regular
- Joined
- Jun 28, 2010
- Messages
- 212
I have a large data set from our CRM. Different people create contacts in it. So most compulsory fields are left blank or incorrect info. is added. Below is the sample data with the names of the people who created those contacts. There are around 35 people who created these. Now I want to compile a single spreadsheet and send to all these 35 people. First i thought of creating 35 tabs with names of the people who created these contacts and ask them to fill in the blank/incorrect fields. Cells with no color are filled with correct info and Red cells are the ones which need to be corrected. Please suggest how to do achieve this in professional manner without creating 35 tabs. THANKS IN ADVANCE...!!
Here is the sample data... Columns from B till P(red color) needs to be corrected..
Sheet4
<tbody>
</tbody>Excel 2007
Here is the sample data... Columns from B till P(red color) needs to be corrected..
Sheet4
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Contact ID | Created By | Account Name | First Name | Last Name | Department | Field of business activity | Job Title | Generic job title-Corporate/Law firms (whichever is applicable) | Contact Address same like Account? | Mailing street | Mailing town | Mailing State/county | Mailing Zip/Postal Code | Mailing Country | |
2 | 0032000000tzB9p | David | IBA Group | Blank | Patrick | Blank | Blank | Blank | ||||||||
3 | 0032000000tz8Td | David | Fady Sarkis Law Office | Fady | Sarkis | Blank | Blank | Blank | Blank | Blank | Blank | |||||
4 | 0032000000tyOB4 | David | UAE University | Manfred | Malzahn | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank |
5 | 0032000000tyif4 | David | Nony Et Associes | Jerome | Sartorius | Blank | ||||||||||
6 | 0032000000tyRBI | David | Strulik Sa | B | Carneiro | Blank | ||||||||||
7 | 0032000000tyiIL | David | Juris Nearshore | Daniel | Abitbol | Blank | Blank | Wrong info | ||||||||
8 | 0032000000tyQGg | David | Immunoclin | Emeric | Reynaud | incomplete info | Blank | Blank | ||||||||
9 | 0032000000tyNjy | David | UAE University | Mohammed | Hussien Saleh Al-Hemairy | Blank | Blank | Blank | Blank | Blank | Blank | |||||
10 | 0032000000txx7a | Joe | Thx Ltd | Erik | Riegler | Blank | Blank | Blank | Blank | wrong email id | ||||||
11 | 0032000000ty4hp | Joe | Deema | Tamimi | Blank | Blank | Blank | |||||||||
12 | 0032000000tyc0x | Joe | Quan & Associates | Nancy | Quan | Blank | Blank | Blank | Blank | Blank | Blank | Blank | ||||
13 | 0032000000tvqnx | Joe | Richard Sheedy | Richard | Sheedy | Blank | Blank | Blank | Blank | Blank | Blank | |||||
14 | 0032000000tzPwY | Joe | Five Apes, Inc. | Patrick | Chiang | Blank | Blank | Blank | Blank | |||||||
15 | 0032000000tyjCp | Joe | Prysm Inc | Peter | Ullmann | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | ||
16 | 0032000000tybit | Joe | Blue Sands IP | Alan | Sorgi | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | ||
17 | 0032000000tyEmE | Joe | Venti Group LLC | Tony | Eichenlaub | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | ||
18 | 0032000000txxUr | Joe | The Cheesecake Factory Inc | Christine | Vu | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | ||
19 | 0032000000tvrqT | Maria | Covington & Burling LLP | MaryAnn | Hong | Blank | Blank | Blank | ||||||||
20 | 0032000000tyqbu | Maria | Baker & Hostetler LLP | Kelly | Kurtz | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | |
21 | 0032000000tyF0E | Maria | ELLUCIAN | Blank | Wrong info | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | ||
22 | 0032000000twZWW | Maria | Blank Rome LLP | Jamie | Bertha | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | ||
23 | 0032000000twSFK | Maria | Faegre Baker Daniels | Mickie | Potter | Blank | Blank | Blank | Blank | |||||||
24 | 0032000000twSEq | Maria | Faegre Baker Daniels | Michelle | Davis | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank |
<tbody>
</tbody>
Last edited: