+ Reply to Thread
Results 1 to 1 of 1

Locating data based on cell color & pasting to new sheet

  1. #1
    Registered User
    Join Date
    06-03-2004
    Posts
    4

    Locating data based on cell color & pasting to new sheet

    I currently have some VBA code that compares two worksheets and color codes the cells in both worksheets based on what is found between the two (green if match, orange if no match).

    What I need to do is search through sheet 1 for all green cells, copy the contents of that cell and a cell three cells to the left, then place the contents of both cells in columns A and B on sheet 3 with a column header of "Keeps"- and loop through the worksheet until it hits a blank cell.

    This then needs to be repeated for all orange cells, placing the contents in columns C and D of the sheet 3 with a column header of "Takes".

    For sheet 2, I need it to locate each of the unhighlighted cells (not green or orange), check to see if it is a duplicate in sheet 2, discard if it is or place the results in columns E and F of sheet 3 if its not a duplicate with a column header of "Puts".

    This has to be done in VBA with no interaction by the user. I'll get around to figuring out how to let the user select two worksheets in two different workbooks later.

    And this is for Excel 2K.

    Any assistance greatly appreciated.
    Last edited by riggsd; 02-10-2005 at 04:24 PM. Reason: Forgot Excel version

+ Reply to Thread

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