I would like to modify that code with these specification:
I need to keep all colors in cells. But if there's no data in column G but some or all other cells in the same row have data, it will clear all data in the row but at the end of the code, if there a empty row between 2 rows with data, the one after the empty row will go up 1 row.
How can i do that?
Thanks for your help
For i = 2 To Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
If i = 1 Then
i = 2
For j = 1 To 55
If j = 7 Then
If Cells(i, j).Value <> "" Then
i = i - 1