I have a spreadsheet that contain 4 columns. the first on is a string (Name), second (from) and third (To)are double, the last column is again string (Code).
I need a macro to check following steps
1- if "Name"="Name" then
2- check "Code" column if the string is repeated then
3- remember "from" value and take "To" value from the last repeated cells of the "Code"!!
what I need is to merge "From" and "To" in repeated cells of the "code" and copy the NEW "Name", "From", "To" and "Code" columns into a new sheet.

I can send excel file if you need