i am new in the world of excel vba, so basicly i know nothing about vba .
in the attachments a file that explain with color and steps for what i try to do with vba.
i use this macro to find duplicate value from the lastrow to the first row.
LastRow = StartCell.SpecialCells(xlCellTypeLastCell).Row
lastcolumn = StartCell.SpecialCells(xlCellTypeLastCell).Column
Dim rngData As Range, ACell As Range, Cell As Range
Dim I As Long, J As Long, n As Long
Set rngData = Range(StartCell, sht.Cells(LastRow, lastcolumn))
For I = LastRow To 1 Step -1
For J = lastcolumn To 1 Step -1
Set ACell = rngData.Cells(I, J)
For Each Cell In rngData
If Cell <> Empty And _
Cell.Value = ACell.Value And _
Cell.Address <> ACell.Address Then
Cell.Cut Destination:=Cell.Offset(0, 8)
n = n + 1
in the file example , the green cells are "CELL" and the orange cell are "ACELL"
so basicly this macro keep offset duplicated value by 8 column ."cell"
what i want to do is the inverse , keep offset duplicated value by 8 column. "ACELL".