Automatic distribution of raw data?

C

Cato Myrkaskog

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top