I have a large worksheet (which is exported from Access and updated every 10 mins)in which I want to filter down to 4 smaller worksheets. In column D there are 4 different environments in which I have created a new worksheet for each environment.

Is it possible to filter and extract the rows automatically (every 10 mins) to the relevant worksheets?

I have used the query wizard but it only allows you to do 2 environments at a time, and it is a manual process. I have also tried the manual query and when I select an environment it still brings up the non-required environment rows but leaves the environment column blank.

Any help appreciated.

Sorry if this appears more than once, I have had problems posting today.