Hi guys, im trying to filter data based on certain criteria and have this update manually and im not sure if it's even possible.

What i have is a table with lots of customers in, customers are assigned a tier of 1 - 5 based on their size, the table has i field for eah customer with expiry date, no of days to expiry and number of months to expiry.

what im trying to do is create a seperate tab that filters this mass of data into only displaying, tier 1 customers that expire in a year, tier 2 ustomers that expire in 6 months, tier 3 customers that expire in 3 months, then 2 months and 1 month. (you get the picture) the problem is i want this to update itself so i dont have to do it every day

is this possible as im stumped with my limited knowedge and drawing a google blank.

Thanks a lot.