i have a report where i would like to create a sub to perform a check.
I have data in the two blocks (attached) that will always change from 1 day to the next.
I have highlighted in yellow "Today" and "Yesterday"
I would like some code that can read the data in "Today" and "Yesterday" and if it is identical, create a warning message "Data Identical"
The thing is, it must check lines up to the black fill and then move down and so on. I have labled the data areas that need to be checked "Report 1-9"
If it is long code to write, if i get the beginning, i should be able to extrapolate