Need to extract all the red cells into 1 single column

[karthisiva]

2015-03-26_120352.jpg

Hi,

as per attached i have a sheet where im having few cells highlighted as red, the sheet has columns from a to az... all columns has few cells highlighted in red.

i want to extract all the red into 1 column or in seperate sheet, can anyone help me to do this

thanks

[Glenn Kennedy]

Are the cells formatted red "randomly/manually" by you or a a result of a conditional formatting formula, or what????

[karthisiva]

Hi Glen,

This is what we get from our vendor and they do this manually not by any formula or code.

Thanks

[Glenn Kennedy]

You can do it manually, column, by column, using DATA/FILTER/SORT BY COLOUR

but (so far as I am aware) there is no automated way of doing this...

[JazzKult]

How about this? Just remember to add a sheet named "New sheet" (you can change the name in the code if you want):

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[Glenn Kennedy]

VBA is a dark art. I really will have to try to understand it someday!

[karthisiva]

Hi john

can you please give me step by step instruction as i tried to do this now and cant see anything happening. i saved the sheet in micro enabled format and saved the code and run it

[JOHN H. DAVIS]

Can you attach a file depicting what you show above? To attach a file, Click Go Advanced, scroll down to the Manage Attachments button, browse to the required file, and then push the Upload button.

[JOHN H. DAVIS]

The macro should go in a Standard Module. You can find it on the Insert Menu from the VBE. Copy and paste the code there. Then you can run it. Let me know if you need further help.