+ Reply to Thread
Results 1 to 10 of 10

Macro to import data containing Conditional formatting

  1. 07-12-2021, 11:24 PM #1
    Howardc1001
    Howardc1001 is offline
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,715

    Macro to import data containing Conditional formatting

    I have a file that I want to import the data that have been coloured using Conditional formatting


    I have code to open a file, but need this amended to only copy the data that has been coloured containing conditional formatting


    Please Login or Register  to view this content.

    Your assistance is most appreciated

    I have also posted on https://www.myonlinetraininghub.com/...matting#p21496
    Attached Files Attached Files
    Last edited by Howardc1001; 07-13-2021 at 01:12 PM. Reason: Added Cross Link
    Reply With QuoteRegister To Reply
  2. 07-14-2021, 05:13 AM #2
    Howardc1001
    Howardc1001 is offline
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,715

    Re: Macro to import data containing Conditional formatting

    I tried to use VBA to copy only the coloured data to sheet2, but cannot get it to work

    Once this is copied I can then import the data


    Please Login or Register  to view this content.


    It would be appreciated if someone could amend my code
    Reply With QuoteRegister To Reply
  3. 07-14-2021, 06:02 AM #3
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,364

    Re: Macro to import data containing Conditional formatting

    See: https://docs.microsoft.com/en-gb/off....displayformat

    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  4. 07-14-2021, 08:31 AM #4
    Vraag en antwoord
    Vraag en antwoord is offline
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Macro to import data containing Conditional formatting

    You can also filter by colors. Much faster than copying row by row.

    Please Login or Register  to view this content.
    Messages have been translated from Dutch to English by means of google translate.
    Reply With QuoteRegister To Reply
  5. 07-14-2021, 11:29 AM #5
    Howardc1001
    Howardc1001 is offline
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,715

    Re: Macro to import data containing Conditional formatting

    thanks Vraag en Antwoord

    Where do I amend code to paste the data always on Sheet2 ?
    Reply With QuoteRegister To Reply
  6. 07-14-2021, 11:30 AM #6
    Howardc1001
    Howardc1001 is offline
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,715

    Re: Macro to import data containing Conditional formatting

    Thanks for the help Trevor
    Reply With QuoteRegister To Reply
  7. 07-14-2021, 11:39 AM #7
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,364

    Re: Macro to import data containing Conditional formatting

    You're welcome. Thanks for the rep.
    Reply With QuoteRegister To Reply
  8. 07-15-2021, 10:17 AM #8
    Howardc1001
    Howardc1001 is offline
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,715

    Re: Macro to import data containing Conditional formatting

    Hi Vraag en antwoord

    It would be appreciated if you could kindly attend to my message in Post # 5 so that the data will always copy on to sheet2

    i need the code below amended

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  9. 07-15-2021, 10:24 AM #9
    Vraag en antwoord
    Vraag en antwoord is offline
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Macro to import data containing Conditional formatting

    It's not that hard to try it yourself
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  10. 07-15-2021, 11:09 AM #10
    Howardc1001
    Howardc1001 is offline
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,715

    Re: Macro to import data containing Conditional formatting

    Many thanks for the help
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA to Export and Re-Import Conditional Formatting Rules
    By Junior1 in forum Tips and Tutorials
    Replies: 10
    Last Post: 10-22-2022, 12:22 AM
  2. VBA Macro button - conflict with conditional formatting and data validation
    By Ria77 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-13-2017, 07:08 AM
  3. Excel Form - need macro to add multiple rows with data validation & conditional formatting
    By Winter2014 in forum Excel Programming / VBA / Macros
    Replies: 56
    Last Post: 03-11-2014, 03:56 PM
  4. Macro for Conditional Formatting between books to compare row data
    By eg6791 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-20-2014, 06:11 PM
  5. Conditional formatting and data validation with VBA macro
    By JantjeB in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-07-2014, 05:28 AM
  6. Import Macro sometimes adding data to end of last import
    By himynameisiain in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-30-2013, 07:06 AM
  7. [SOLVED] Highlight Row based on data on separate sheet - Macro or Conditional Formatting?
    By Richww2 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-09-2012, 06:12 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1