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

ravi_firedup

New Member
Joined
Jul 16, 2010
Messages
3
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 !!!!!!!!!!!!!
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Watch MrExcel Video

Forum statistics

Threads
1,129,800
Messages
5,638,415
Members
417,025
Latest member
MusterDuster

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top