Transpose according to color.interior.index

[YasserKhalil]

Hello everybody
I have a lot of data in range("A1:A"& LastRow)
there are some cells which has a red color of interior index number 3 .
According to that index number of the color I want to transpose the data beginning with this index number till before the next one .. The desired results are in Sheets("Result") to illustarte the desired results..
Please don't depend on the string (Header) as it is just a sample to the original wb

[JieJenn]

Try this code see if it works.

Please Login or Register  to view this content.

[YasserKhalil]

Wonderful Mr. JieJenn
Really great and very good code
Just a little point .. The last line of sorting data is not acceptable for me as the string Header is just a sample but real data will not be sorted correctly .. So the data will not be in order
How can we move the rows from the last row to the first row?!

[JieJenn]

What do you mean? There are other parameters you can specify for the Sort Statement. If you want avoid sorting the list, I guess the For loop just need to be reversed.

[YasserKhalil]

I reversed the loop but it didn't work!!!

[JieJenn]

Use this

Please Login or Register  to view this content.

[YasserKhalil]

Yes it's perfect
Thanks a lot for this great help
You are PERFECT