Noob here.
I have tried so many different ways to compare and find the changes of Columns L&M based on Q.
Tried Access but it only exports two columns and I have no idea what it is referencing OR it extracts all rows. I don't really know my way around ACCESS.
Tried Conditional formatting but it didn't work.
Tried everything.
What I need:
Greatly appreciate your help.
I have tried so many different ways to compare and find the changes of Columns L&M based on Q.
Tried Access but it only exports two columns and I have no idea what it is referencing OR it extracts all rows. I don't really know my way around ACCESS.
Tried Conditional formatting but it didn't work.
Tried everything.
What I need:
- Find what rows have changes in columns L&M from the daily UPDATES sheet, compared to the current running DATA sheet and highlight.
- Highlight / add the changes to DATA sheet col L&M from UPDATES sheet col L&M
- Any new rows found in the UPDATES sheet, also add to the DATA sheet
- Col Q is the unique ID #.
Greatly appreciate your help.
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q |
DATE | Pet | Location | FIRST_NAME | LAST_NAME | TELEPHONE | ADDRESS | CITY | PROVINCE | POSTAL_CODE | CALLED | VISITED | Status | Vet | Desc | Unique ID | |
dd/mm/yyyy | Sheep | yes | no | 123 | ||||||||||||
dd/mm/yyyy | Dog | no | no | 456 | ||||||||||||
dd/mm/yyyy | Rabbit | yes | yes | 789 | ||||||||||||
DATA TAB | ||||||||||||||||
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q |
DATE | Pet | Location | FIRST_NAME | LAST_NAME | TELEPHONE | ADDRESS | CITY | PROVINCE | POSTAL_CODE | CALLED | VISITED | Status | Vet | Desc | Unique ID | |
dd/mm/yyyy | Sheep | yes | yes | 123 | ||||||||||||
dd/mm/yyyy | Dog | no | yes | 456 | ||||||||||||
dd/mm/yyyy | Rabbit | yes | yes | 789 | ||||||||||||
dd/mm/yyyy | Cat | no | no | 666 | ||||||||||||
dd/mm/yyyy | Bird | no | no | 777 | ||||||||||||
UPDATES | ||||||||||||||||