SilverFoxx79
New Member
- Joined
- Nov 12, 2012
- Messages
- 2
Hello
I'm a bit of a noob and need some help!
I have 2 property spreadsheets to combine, the both have roughly the same data but both have some missing compared to each other and most data has been changed/updated. So I wish to combine and update both into a master spreadsheet without creating duplication of those rows/fields/cells which have not changed.
So far I have only been able to merge the spreadsheets with duplication of the rows, there is to much data to filter manually. I've been trying to work out a formula to combine both sheets based upon the only constant cells throughout both sheets which is the data held in column C (Code) which is unique to each building. The building names have been changed and the owners are constantly changing.
Here's an example
<tbody>
</tbody>
I'd greatly appreciate any advice you could give me.
I'm a bit of a noob and need some help!
I have 2 property spreadsheets to combine, the both have roughly the same data but both have some missing compared to each other and most data has been changed/updated. So I wish to combine and update both into a master spreadsheet without creating duplication of those rows/fields/cells which have not changed.
So far I have only been able to merge the spreadsheets with duplication of the rows, there is to much data to filter manually. I've been trying to work out a formula to combine both sheets based upon the only constant cells throughout both sheets which is the data held in column C (Code) which is unique to each building. The building names have been changed and the owners are constantly changing.
Here's an example
| A | B | C | D | E |
| Community | Building Name | Code | Unit | Name |
| Uptown 1 | Block A | 1 | 201 | Smith |
| A Block | 1 | 301 | Jones | |
| Uptown 3 | A Block | 1 | 302 | Smith |
<tbody>
</tbody>
I'd greatly appreciate any advice you could give me.
