auto.pilot
Well-known Member
- Joined
- Sep 27, 2007
- Messages
- 734
- Office Version
- 365
- Platform
- Windows
I'm seeking a VBA method to identify changed values month over month. My spreadsheet has about 80,000 rows. Column H includes month-end dates, column C includes unique ID numbers that never change and column E includes values that may change every month. I am attempting to highlight rows in the current month, when the value in column E is different than the prior month (by ID numbers).
Example: There are several thousand rows used for each month-end date. Column H includes several thousand entries related to 9/30/18, then a different number of entries for 8/31/18. In total, the 80,000 rows span several years. I only need to compare value in column E for the current month to the value in column E in prior month by ID number.
Here's a small snippet of the data, with column C on the left, column E in the middle and column H on the right.
If it matters, my header row is 4, with data starting in row 5
Hoping this makes sense. I've use code that compares complete columns to other columns, but this is very different and I'm stumped!
Thanks in advance.
Jim
Example: There are several thousand rows used for each month-end date. Column H includes several thousand entries related to 9/30/18, then a different number of entries for 8/31/18. In total, the 80,000 rows span several years. I only need to compare value in column E for the current month to the value in column E in prior month by ID number.
Here's a small snippet of the data, with column C on the left, column E in the middle and column H on the right.
Code:
ABC AAA 09/30/18
EFG BBB 09/30/18 <<< highlight this row, because the value BBB differs from the value BAA on 8/31/18
ZZZ CAA 09/30/18
LMN AAA 09/30/18
ABC AAA 08/31/18
EFG BAA 08/31/18
ZZZ CAA 08/31/18
LMN AAA 08/31/18
If it matters, my header row is 4, with data starting in row 5
Hoping this makes sense. I've use code that compares complete columns to other columns, but this is very different and I'm stumped!
Thanks in advance.
Jim