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

On Monday, December 31, 2012 11:28:27 AM UTC+3:30, wrote:
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.



It is the file
https://dl.dropbox.com/u/56812294/MAJOR_s1.xlsx