1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Need excel Macro for copy paste colored rows

Discussion in 'Business Applications' started by qageek, Jul 2, 2007.

Thread Status:
Not open for further replies.
Advertisement
  1. qageek

    qageek Thread Starter

    Joined:
    Jul 2, 2007
    Messages:
    3
    Hi,
    I am trying to sort the colored rows, copy and paste it in particular format.
    I have attached a sample excel file.
    1. A cell has values which are Purple in color.
    2. B cell has values, yellow, Blue and White in color.
    3. I want concatenate A-Purple, B Yellow and paste it in next work sheet "Result"- Col2
    4. Blue rows need to be copied and pasted to Col2
    5. White row need to get pasted to Col4
    6. Want to repeat this for whole worksheet.
    Can you please suggest a macro for this?
    Thanks,
     
  2. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,840
    gageek, I don't think there is an Example Excel sheet.
     
  3. qageek

    qageek Thread Starter

    Joined:
    Jul 2, 2007
    Messages:
    3
    Sorry, Please find it..now.
     

    Attached Files:

  4. qageek

    qageek Thread Starter

    Joined:
    Jul 2, 2007
    Messages:
    3
    OOps! looks like, its not displaying the attached files!
    Worksheet 1:

    Work Sheet Name: Test

    Column1 Column 2 Column 3 Column4
    PurpleSample yellow sample
    Blue Sample 1
    Blue Sample 1
    Clear Text


    .........................................................................................


    Worksheet2: Result

    Column 2 Worksheet1 name Test | PurpleSample | yellow sample
    Column 3 Blue Sample 1
    Blue Sample 1
    Column 4 Clear Text
     

    Attached Files:

  5. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,840
    gageek, do the values/Colours always come in groups of 4 rows?
    Will the next entry in Column A be on row 6?
    Do you need the "Test" and "B1" in the cell on the results sheet?
     
  6. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,840
    Assuming that the answers to the questions are yes, yes and no, the attached sheet will do what you want.
    I do not know if you want to transfer the colours as well, this just transfers the values.
     

    Attached Files:

  7. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/591015

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice