Creating sheets with pasted colour-marked rows through a nifty macro command, please

[Arsaces]

Hey guys,

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

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

Generally, this is the process I have in mind: I use colour coding, goo
row or bad row to distinguish between rows. Green in this cas
represents confirmed orders, whereas red represents canceled orders.

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

The sheet of confirmed orders is essentially the same as the previou
sheet (With all the entries), except it has only the green rows paste
into it, while the sheet for canceled orders should only have the re
rows.



Now, in case it's required, here is the plain Excel file that I wor
with. It's "original.jpg"


In the files, "whatiwantittodo" 1 through 4 is what I want it to loo
like. Currently this is all done by hand.

What I would like is, when I do the colour-marking, and then (When I a
finished applying the colour-formatting on the rows) input a macro, th
rows are copied into two newly auto-created sheets, where good entrie
(green) are pasted into one of the sheets, and the bad entries (red) ar
pasted into the other sheet.

I would really want to find a way to optimize this process through
handy macro. It would be a real time-saver. Can anyone please help me?
am using Excel 2010 on Windows 7.

Thank you very much in advance

+-------------------------------------------------------------------
|Filename: original.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=409
|Filename: whatiwantitittodo_1.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=410
|Filename: whatiwantittodo_2.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=411
|Filename: whatiwantittodo_3.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=412
|Filename: whatiwantittodo_4.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=413
+-------------------------------------------------------------------

 

[Arsaces]

Anyone? =/

Hey guys,

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

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

Generally, this is the process I have in mind: I use colour coding, goo
row or bad row to distinguish between rows. Green in this cas
represents confirmed orders, whereas red represents canceled orders.

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

The sheet of confirmed orders is essentially the same as the previou
sheet (With all the entries), except it has only the green rows paste
into it, while the sheet for canceled orders should only have the re
rows.



Now, in case it's required, here is the plain Excel file that I wor
with. It's "original.jpg"


In the files, "whatiwantittodo" 1 through 4 is what I want it to loo
like. Currently this is all done by hand.

What I would like is, when I do the colour-marking, and then (When I a
finished applying the colour-formatting on the rows) input a macro, th
rows are copied into two newly auto-created sheets, where good entrie
(green) are pasted into one of the sheets, and the bad entries (red) ar
pasted into the other sheet.

I would really want to find a way to optimize this process through
handy macro. It would be a real time-saver. Can anyone please help me?
am using Excel 2010 on Windows 7.

Thank you very much in advance

+-------------------------------------------------------------------
+-------------------------------------------------------------------