VBA Coding to identify the color coding in sheet and then copy paste the data into next tab

[ravi_firedup]

Hi All,
I am wrking on some automation i tried a lot and finally gave up, so my last option is to check with the Experts. I hope i will get the solution here or else i have to drop out the Automation itself. Kindly assist me. Here r the details

1) I have a feilds from col J to Col N, not in all the fields data (Numbers) are available (Randam data)
2)The data is color coded in Blue (Font.ColorIndex = 5)
3) Logic : first the conduction should check for Col J then if there is no color code then it should move to Col K, then to Col L, Col M, Col N, Col R, Col BJ, Col BQ
4) If in either of this field data is available with color code then it should copy and paste the data into next tab.
5) Next step is it should move to next Row to search for the above conduction.

Eg :

Data is in following format :

Col J........ Col K........ Col L........ Col M....... Col N
1.000 .....................................................1.000
................1.000
................................1.000
...............................................1.000
.............................................................2.000
1.000...........1.000.........1.000........1.000.....1.000


Only logic is in each row it should search for data with color font Blue if its there then i should copy the entire row to new sheet or it should move to next Row. But the same entry should not repeat twice.
Eg in Row 1 there are 2 entires in the same row so it should copy and paste it only once to next tab.

One more requirement is with continious to Col J to Col N there are 3 more feilds we have to check for the color coding i.e Col R, Col BJ, Col BQ

I hope i have explained it better & i will get the solution for the same.....

Guys....... Plz help me !!!!!!!!!!!!!