Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 12th 12, 11:01 PM
Junior Member
 
First recorded activity by ExcelBanter: Jun 2012
Posts: 4
Default Creating sheets with pasted colour-marked rows through a nifty macro command, please

Hey guys,

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.

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: 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.

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

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



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


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

What I would like is, 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.

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

Thank you very much in advance!
Attached Images
     

  #2   Report Post  
Old June 13th 12, 06:42 AM
Junior Member
 
First recorded activity by ExcelBanter: Jun 2012
Posts: 4
Default

Anyone? =/

Quote:
Originally Posted by Arsaces View Post
Hey guys,

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.

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: 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.

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

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



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


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

What I would like is, 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.

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

Thank you very much in advance!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help creating a formula that will auto post amts when marked. Cindy E. Excel Worksheet Functions 1 April 21st 08 03:43 PM
Creating a macro where values are copied and pasted into a sheet Don Guillett Excel Programming 2 January 11th 07 07:11 PM
Creating a macro where values are copied and pasted into a sheet OKROB Excel Programming 0 January 11th 07 05:03 AM
Copying marked rows to another sheet Leitwolf25[_6_] Excel Programming 0 May 13th 06 06:13 PM
use vb to delete marked rows Phil Excel Programming 5 July 16th 04 09:19 PM


All times are GMT +1. The time now is 01:26 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017