Need help - filtering data into seprate Sheets.

Hi All,

First I just want to say Hi, long time lurker, first time poster.

I am just trying to arrange a new process at work and what I need to do is take a master data file which has lots of information, but then break it down by country and status across different sheets.

For example:

I want to be able to paste data into sheet one. This contains country and status. Now I want this then to filter into several sheets depending on the criteria so Sheet 2 to show All Russia orders with the status delivered and signed for, Sheet 3 to show Russia orders and the status In transit and with driver.

Sheet 4 to show China order with the status sold out.

I need it in a way I can just paste the data into the master data tab, and the rest of the sheets populate based on the criteria set.

I have very basic Excel knowledge and I have been playing around and googling for hours and now my head hurts.lol.

I appreciate any help.

Thanks.

This could possibly be adapted to what you need.

Read the 'NOTE' on the Master sheet and test it out.

Originally Posted by ChemistB

So is the master sheet going to be constantly written over or will it be constantly compiled?
If the first, you'll need VBA, with the second, you could use formulas but things might get very slow with large amounts of data.

Each day new data will be pasted over the old, the format etc will always remain the same.