+ Reply to Thread
Results 1 to 1 of 1

Populate different sheet based on cell color

  1. #1
    Registered User
    Join Date
    06-17-2010
    Location
    Nowhere, NZ
    MS-Off Ver
    Excel 2007
    Posts
    9

    Populate different sheet based on cell color

    I hope the description is accurate enough.

    I want to populate a different sheet, say Sheet1, with the data in columns I, C, and N (starting in row 2) from sheet "Page1-1" (corresponding to columns A, B, and C in Sheet1, starting at row 4), in that order, IF the cell in column N is red (or simply not "no fill").

    It sounds simple enough, but I don't know enough about VBA to make it work. Any help is appreciated, and the simpler the better.

    Side note: How would I make it a button and/or automatically update?
    Last edited by goldenr1; 07-19-2010 at 04:30 PM.

+ 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