I using Excel 2010
I have tabs on one spreadsheet - Main, O and B.
In the Main Tab I have the following data (example data)
Matter Sort Date
1 B 21/10/2011
2 O 21/10/2014
3 B 20/10/2013
I want to make sure that anything with Sort O - copies that row of data into Tab O (this case would be 1 row)
and anything with Sort B copies that row of data into Tab B (in the example 2 rows).
The Main tab data gets populated on a daily basis with new data
Any help would be appreciated