I have successfully been able to make a new worksheet for each item based on name. Now heres the tricky part: I want to filter each worksheet based on column M, then I would like to analyse the sorted data in pairs and copy rows if A) column J is equal B) Column BV is +-5 of each other C) column G is +- 90 days of each other.
I realize this seems to be a pretty daunting task. So if you don't want to take the large amount of time to help me out, could someone with a good excel knowledge please tell me if this is @ least possible and point me in the direction of any useful resources in my quest.
Thanks
Bookmarks