+ Reply to Thread
Results 1 to 6 of 6

VBA or Macro to copy highlighted cells and paste into a new sheet

  1. #1
    Registered User
    Join Date
    05-28-2010
    Location
    Redlands, CA
    MS-Off Ver
    Excel 2010
    Posts
    10

    Smile VBA or Macro to copy highlighted cells and paste into a new sheet

    Hey Guru's,
    I'm so grateful, in advance, for any help on this one--

    I have a set of data on sheet1 indicating test scores and basic information. At the top of the data, I have some drop-down menus that allow me to select certain minimal score results. I used conditional formatting to highlight the rows of individuals that meet the selected criteria from the top of the screen. You will notice in the screenshot, that I placed a button at the top called "Go!". Ultimately, I'd like for when I push the "Go!" button, Excel will copy the highlighted cells and paste them into sheet2 (beginning on row 2 as I have a title bar in row 1).

    ExcelSnippet.JPG

    Thank you!

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: VBA or Macro to copy highlighted cells and paste into a new sheet

    You can not evaluate a cell with conditional formatting. In other words, you can not test the colour of a cell if that cell is coloured using conditional formatting.

  3. #3
    Forum Contributor
    Join Date
    08-11-2013
    Location
    london
    MS-Off Ver
    Excel 365
    Posts
    270

    Re: VBA or Macro to copy highlighted cells and paste into a new sheet

    did you want to data to over write the previous pasted data?

  4. #4
    Registered User
    Join Date
    05-28-2010
    Location
    Redlands, CA
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: VBA or Macro to copy highlighted cells and paste into a new sheet

    Yes, it would overwrite any previously pasted data

  5. #5
    Registered User
    Join Date
    05-28-2010
    Location
    Redlands, CA
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: VBA or Macro to copy highlighted cells and paste into a new sheet

    If it is not possible to copy cells that were highlighted via conditional formatting, then my interest would be to copy rows based on the criteria at the top. For example, in the screenshot, the criteria is set at a score of 40 for typing, 80 for excel, 80 for word, etc. I would like the button to copy any rows that meet and/or exceed those scores and then paste into Sheet2 (beginning on row 2).

  6. #6
    Registered User
    Join Date
    05-28-2010
    Location
    Redlands, CA
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: VBA or Macro to copy highlighted cells and paste into a new sheet

    Thanks, I figured out a workaround...

+ 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 and Paste based on Red Highlighted Cells
    By rlsublime in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-15-2013, 12:59 PM
  2. Copy Paste cells into a new sheet based on criteria macro
    By Clessie1919 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-19-2012, 02:43 AM
  3. Macro Help! Copy/Paste Highlighted Row
    By TShelt in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-16-2011, 12:30 PM
  4. [SOLVED] Macro to copy highlighted cells to csv file
    By Martin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-14-2006, 04:00 PM
  5. Macro to copy range of cells and paste into 1 sheet
    By Dean in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-19-2006, 08:55 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