I'm constructing a sheet to aid 5 departments handle backlogs.
The raw data is given to us from a database, in an excel format, once
every night.

I'd like to split the raw data from tab1 to tab2-6, depending on
department, say Department Blue, Green, Red, Yellow and Brown

So I name the tabs Raw, Blue, Green, Red, Yellow and Brown.

So if the raw data is like this:
Order - Agent - Product - Date - Department
Could I have excel automatically copy all orders from tab 1 where
department=Blue to Tab Blue?
And would it eventually be possible to add a check to that procedure
to check if the order is already there?

In other word; If department=Blue, and order does not exist in tab
Blue, copy entire row to tab blue.

I guess this would require a VBA code?

--
Cato Myrkaskog