HI
I have sheet contains items in column C ,G what I want replacing items for column C based on column G . the code does it, but the problem if there are items in column G and the adjacent cells in column C are empty will also bring new items from column G i don't want it . should keep empty for adjacent cells in column C .
Sub Demo1()
Dim V, S%
V = Sheets(4).UsedRange.Columns(7).Value2
Sheets(4).UsedRange.Columns(3).Value2 = V
End If
End Sub
would appreciate if anybody help .