+ Reply to Thread
Results 1 to 9 of 9

Copy and paste without Conditional Formatting

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,313

    Copy and paste without Conditional Formatting

    Hello:

    Please refer to attached file.
    I have data in Sheet1 as shown. (Note the color in the Sales are due to Conditional formatting).
    I need VB Code to copy data A1:F5 from Sheet1 and paste at cell A5 in "Backup" Sheet with the same color and format
    but do not need Conditional formatting in Backup sheet.
    Need to make sure that i get
    Let me know if you have any questions.
    Thanks.

    Riz
    Attached Files Attached Files

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,526

    Re: Copy and paste without Conditional Formatting

    Hi Riz,

    Try this code.
    You stated A1:F5 in your first post, but your data is A1:F7.
    I wrote code for A1:F5, you can probably figure out where to make the changes, there are two places.

    Please Login or Register  to view this content.
    Last edited by skywriter; 09-16-2015 at 10:48 PM.
    As a reminder, once your original request has been fulfilled please mark this thread as SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

    If you are happy with my help, then please consider clicking the add reputation button in the lower left hand corner of this post.

  3. #3
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,313

    Re: Copy and paste without Conditional Formatting

    Hi skywriter:

    Seems to work great except would ask if the column width of both original and backup remains the same.
    Refer to attahced sheet
    Please help modify the code accordingly
    Please let me know if you have any questions.
    Thanks.
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,635

    Re: Copy and paste without Conditional Formatting

    Sorry re-read the initial post
    you want the conditional format outcomes without the conditional formats

    another alternative is to copy data, delete conditional format and replicate the "conditions" in VBA

    Please Login or Register  to view this content.
    i dont know how to write the rest....as the example the CF is broken as it points to external file
    Last edited by humdingaling; 09-16-2015 at 11:41 PM. Reason: misread OP query
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  5. #5
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,313

    Re: Copy and paste without Conditional Formatting

    Hello:

    I get lots of file to work with every day and there will be lots of CF to delete
    Please let me know if you have any questions.
    Thanks.

    Riz

  6. #6
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,313

    Re: Copy and paste without Conditional Formatting

    Hi humidangling:

    Works great.
    Thanks this would work.
    Riz

  7. #7
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,635

    Re: Copy and paste without Conditional Formatting

    yeah sorry didnt read the post correctly

    deleting the CF is easy part, replicating is not if the CF changes from file to file

    sky's method would be the better choice in that case as you need to copy the display format rather than what the format actually is

  8. #8
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,635

    Re: Copy and paste without Conditional Formatting

    Quote Originally Posted by rizmomin View Post
    Hi humidangling:

    Works great.
    Thanks this would work.
    Riz
    really? im surprised unless i am reading the initial question incorrectly again

    I have data in Sheet1 as shown. (Note the color in the Sales are due to Conditional formatting).
    the CF is broken the example but i would of thought the CF changes some cells green?
    if the cells are "showing" green on your real example and would not copy it green over to the backup
    it would take the original color underneath

  9. #9
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,526

    Re: Copy and paste without Conditional Formatting

    Thanks for the rep. points.

+ 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. Copy/Paste - without Conditional Formatting
    By timothyjquinn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-18-2013, 01:12 PM
  2. [SOLVED] Copy & paste conditional formatting?
    By Ltat42a in forum Excel General
    Replies: 15
    Last Post: 10-02-2012, 01:55 AM
  3. Excel 2007 : conditional formatting: Copy/Paste
    By blizz in forum Excel General
    Replies: 4
    Last Post: 04-07-2011, 08:57 AM
  4. Conditional Formatting Copy & Paste
    By adam2308 in forum Excel General
    Replies: 2
    Last Post: 06-07-2010, 06:03 PM
  5. Copy & Paste without removing conditional formatting
    By Barking_Mad in forum Excel General
    Replies: 6
    Last Post: 03-16-2010, 07:58 PM
  6. Copy paste Conditional Formatting
    By Bud Hughes in forum Excel General
    Replies: 3
    Last Post: 10-01-2005, 07:05 PM
  7. [SOLVED] Copy Paste Conditional Formatting
    By Bud Hughes in forum Excel General
    Replies: 6
    Last Post: 10-01-2005, 10:05 AM

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