Creating sheets with colour-marked cells? Help a complete newbie out!

Hey guys, awesome forum you've got going here

I have an Excel spreadsheet that seems quite simple to work with. The catch? I've got tens of these to work with on a daily basis.

original.jpg

The idea is generally that I have this spreadsheet for monitoring orders on a certain batch. After 14 days, we determine if the orders were confirmed or if they were canceled whereas the orders are sorted in their own sheets (confirmed and canceled).

Generally, this is the process I have in mind:

whatiwantitittodo_1.jpg

I use colour coding, good row or bad row to distinguish between rows. Green in this case represents confirmed orders, whereas red represents canceled orders.

whatiwantittodo_2.jpg

Now, through a macro of some sorts, two new sheets are created, where each set of rows are copied and pasted.

whatiwantittodo_3.jpg

This is how the sheet for confirmed orders should look like.

whatiwantittodo_4.png

And this is how the sheet for canceled orders should look like.

Currently I do this by hand and I would really want to find a way to optimize this process through a handy macro. Can anyone please help me? I am using Excel 2010 on Windows 7.

Thank you very much in advance!

Anyone? :/

Okay, sorry about that. I thought the screenshots would simplify what I wanted to go for.

sample_original.xlsx

Here is the plain Excel file that I work with.


wip.xlsx

Here is what it should look like.

Currently this is all done by hand. When I do the colour-marking, and then (When I am finished applying the colour-formatting on the rows) input a macro, the rows are copied into two newly auto-created sheets, where good entries (green) are pasted into one of the sheets, and the bad entries (red) are pasted into the other sheet.

Thank you very much beforehand for any help.

Can somebody please help me?