WhiteRaven76
New Member
- Joined
- Jun 27, 2022
- Messages
- 9
- Office Version
- 365
- Platform
- Windows
I am trying to make a VBA that compares a row from Book1 to Book2.
If there are any differences it will:
This is a sample of what the sheets will look like. Each sheet will have between 500 and 1500 rows. If anyone has any advice, I would be greatly appreciative!
If there are any differences it will:
- Create a new sheet in Book1
- Copy the row from Book2
- Copy the row from Book1 and highlight it yellow
- Skip a line (so each difference is separate from the others)
This is a sample of what the sheets will look like. Each sheet will have between 500 and 1500 rows. If anyone has any advice, I would be greatly appreciative!
Address | Seq. | Status | Usage | Type |
Address 1 | 1 | Status 1 | Usage 1 | Type 1 |
Address 2 | 2 | Status 1 | Usage 2 | Type 4 |
Address 3 | 3 | Status 1 | Usage 1 | Type 3 |
Address 4 | 4 | Status 2 | Usage 1 | Type 2 |
Address 5 | 5 | Status 1 | Usage 2 | Type 1 |