Need help for coding in excel with VBA macros, multiple dynamic ranges and offsets

[zouhair akkour]

hi, first i want to apologize for my bad english.


i Need help for coding a VBA macros with multiple dynamic ranges and offsets.


Here is the file link for exemple.


https://drive.google.com/open?id=0B73QGIX8lusWLWlRS1dNamFjdEE


thx for help and time.

 

[zouhair akkour]

i will do my best to explain what i want even if my english is bad.

what i want is finding duplicate value then moving cells to another range.

for exemple in T1 i have 2 duplicated value , 26 and 14 .
i delete the value from row 2 and moving the value in row 3 from D3 and F3 to L3 and N3 in T2 then
in T4 i have the value 26 as duplicate , so i delete the duplicated one in L3 and i move B6 to R6 in T5 .