+ Reply to Thread
Results 1 to 2 of 2

VBA to mirror cells between worksheets conditional to cell color

  1. #1
    Registered User
    Join Date
    04-17-2013
    Location
    Michigan
    MS-Off Ver
    Excel 2010
    Posts
    2

    VBA to mirror cells between worksheets conditional to cell color

    I would like to be able to mirror specific cells from worksheet to worksheet in the same workbook based on the cell fill color. Is this possible?

  2. #2
    Registered User
    Join Date
    04-17-2013
    Location
    Michigan
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: VBA to mirror cells between worksheets conditional to cell color

    Job Control worksheet is my main information storage worksheet, Job Assignment worksheet I would like to make a mirror of rows 2 - 29 sorted by the interior color of the cells in row 2......first green then yellow and blue last.

    I am new to VBA, I am trying to find new ways to organize my spreadsheets. Any and all help will be greatly appreciated.

    I attached a sample spreadsheet, In JOB CONTROL worksheet there is a lot of information that I cleared,..names, dates, notes and so on.....

    I really would like the specified range to mirror form worksheet to worksheet.Control and Tracking.xlsx

+ 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