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.
I have also attached the data and expected output here. Thanks.![]()
Please Login or Register to view this content.
Bookmarks