+ Reply to Thread
Results 1 to 2 of 2

Copy and Paste Conditionally formatted rows

  1. #1
    Registered User
    Join Date
    05-31-2017
    Location
    Brunswick, ME
    MS-Off Ver
    2013 (work) and 365 (home)
    Posts
    70

    Copy and Paste Conditionally formatted rows

    Howdy all,

    On the "Consolidated CAT" sheet of the attached workbook, there are rows in the table conditionally formatted to show up gray and red text. I need to copy the values (there are formulas in my full sheet) and the formatting of each of those rows and paste them on the "Exclusions" sheet, starting in A2 and skipping blank rows.

    THEN I need all of the rest of the rows and paste them into the "Universe" sheet starting in B2. As they paste, each row should be numbered in A:A.

    FINALLY, I need all of the data on "Consolidated FAB" to copy over to the "Universe" sheet starting in the row immediately after the end of the "Consolidated CAT" data (numbering as above), AND the numbers in D:E on the "Consolidated FAB" need to copy into H:I on the "Universe".
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    05-31-2017
    Location
    Brunswick, ME
    MS-Off Ver
    2013 (work) and 365 (home)
    Posts
    70

    Re: Copy and Paste Conditionally formatted rows

    bumping up before it gets buried

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA code to copy/paste rows conditionally based on cell value in column
    By thedefense in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-11-2017, 03:20 PM
  2. Replies: 1
    Last Post: 01-04-2017, 06:00 PM
  3. Replies: 1
    Last Post: 01-04-2017, 05:59 PM
  4. VBA to list rows with coloured/conditionally formatted cells
    By jamiem4 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 11-28-2016, 06:27 PM
  5. [SOLVED] Copy conditionally formatted non-adjacent rows
    By Thistledown in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-12-2014, 09:31 AM
  6. [SOLVED] How do you copy only those cells conditionally formatted to a certain colour?
    By strud in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-09-2013, 05:03 AM
  7. how to copy a cell that has been conditionally formatted
    By Dexter Stagg in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-27-2012, 05:03 PM

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