Results 1 to 5 of 5

Copy a row to another sheet based on cell fill color

Threaded View

swatkins1977 Copy a row to another sheet... 10-19-2012, 04:29 PM
patel45 Re: Copy a row to another... 10-19-2012, 05:20 PM
mrice Re: Copy a row to another... 10-19-2012, 05:22 PM
swatkins1977 Re: Copy a row to another... 10-22-2012, 07:19 AM
mrice Re: Copy a row to another... 10-22-2012, 02:55 PM
  1. #1
    Registered User
    Join Date
    10-19-2012
    Location
    Dayton, OH
    MS-Off Ver
    Excel 2010
    Posts
    5

    Copy a row to another sheet based on cell fill color

    I'm sure that this has been covered before but I can't seem to find it. I want a macro that will copy an entire row from one sheet to another based on the fill color of one cell. Since I will be continually adding to the main sheet this will need to copy to the next empty row when it runs.

    In my sample attachment, if the cell is green I want the row copied to the "Good" sheet and if it is red to the "Bad" Sheet.

    Thanks for any help.

    Steve
    Attached Files Attached Files
    Last edited by swatkins1977; 10-19-2012 at 04:36 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1