Copy cell that next to color cell to another sheet

[babyfufu]

Hi all, I would like to copy Sheet 1's Cells(i,1), Cells(i,3) and Cells(i,4) in text format to Sheet 2, if Sheet 1's Cells(i,6) is color cell. The Sheet 1's Cells(i,1), Cells(i,3) and Cells(i,4) will become Sheet 2's Cells(i,1), Cells(i,2) and Cells(i,3). I tried to turn this into VBA, but seems it doesn't work, please help.

Please Login or Register  to view this content.

I have also attached the data and expected output here. Thanks.

[Mumps1]

Try:

Please Login or Register  to view this content.

[babyfufu]

Thanks a lot! It works perfectly.

[Mumps1]

You are very welcome.