Sorting data (dates) in one sheet and finding the sorted data in another sheet?

Hi all,

I have a situation where I have developed a spreadsheet containing some data I'm interested in sorting based on certain criteria. This data is related to another separate sheet and these sheets can't be combined so that's not a solution. Both columns have date as a variable so I'm basically interested in finding dates found in sheet one in sheet two.

Often, when sorting, it may be that the dates are wide apart, so picking out the dates manually in sheet number two is cumbersome and time consuming.

Is there a solution for this? I'm posting in the VBA forum, but maybe it could be solved without.

Sorting.png

Thanks in advance for any help.


Elijah