Multiple Sheet Check and Data Return
Each month I have to put together a collection of data to compare from different sources. Two of the sources have older material and I am trying to find a way to not duplicate items I have already checked.
Can someone help me put together a formula that is something like the following.
Check box if Name (Sheet 1) equals Name (Sheet 2) AND Receive Date (Sheet 1) OR Receive Date (Sheet 2) is in the last 60 days.
I then pull a report to verify data based on what boxes were checked each month.
I currently have 7 sheets that have unique data. Of these only 4 can be combined (working on that now) to one location. The other two are required to be separate.
Help Article Resources
Check out the Formula Handbook template!