Hi hiker95
Thank you very much for the time that you took to think about the code to make this happen. The code makes exactly what is in the 3 cases that I gave you. I was just
playing with the sheets and I noticed that I did not explain very well the situation, so that was my bad.
I think the only thing to make this work as I'm needing is to compare 2 sheets (sheet1 is gonna be the one that has the newest and accurate information), and be able
to identify what was removed and/or added, not only comparing the number of rows.
for instance in the next screenshoot show how I have:
1. same project number in both sheets, but I need the value from sheet1 (the value from the database system)
2. projects that I has in sheet2 (my tracking), but are not anymore in sheet1 (database), and I need to identify that and to call the person responsible why he deleted
that from the database.
3. projects that are in sheet1 (database), but I dont have that in sheet2 (my tracking), and I need to call the person, and ask why he added a new one, and did not
tell me that he is starting a new project
I hope I'm not complicating things nd I really say thanks for your cooperation
Excel 2012
| A | B | C |
---|
1 | 1 | A1 | |
2 | 2 | A2 | |
3 | 3 | A3 | |
4 | 4 | A4 | |
5 | 5 | A5 | |
6 | 6 | A6 | |
<colgroup><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1
Excel 2012
| A | B | C |
---|
1 | 1 | A1234 NOTE THAT IS OTHER VALUE | |
2 | 8 | A8 | |
3 | 9 | A9 | |
4 | 10 | A10 | |
5 | 11 | A11 | |
<colgroup><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet2
Excel 2012
| A | B | C |
---|
1 | 1 | A1 | |
2 | 2 | A2 | this was in Sheet1, but not in Sheet2 |
3 | 3 | A3 | this was in Sheet1, but not in Sheet2 |
4 | 4 | A4 | this was in Sheet1, but not in Sheet2 |
5 | 5 | A5 | this was in Sheet1, but not in Sheet2 |
6 | 6 | A6 | this was in Sheet1, but not in Sheet2 |
7 | 8 | A8 | this was in Sheet2, but not in Sheet1 |
8 | 9 | A9 | this was in Sheet2, but not in Sheet1 |
9 | 10 | A10 | this was in Sheet2, but not in Sheet1 |
10 | 11 | A11 | this was in Sheet2, but not in Sheet1 |
<colgroup><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet3