Need excel Macro for copy paste colored rows

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

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,
 

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
 

Attachments

OBP

Joined
Mar 8, 2005
Messages
19,895
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?
 

OBP

Joined
Mar 8, 2005
Messages
19,895
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.
 

Attachments

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

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 807,865 other people just like you!

Latest posts

Staff online

Top