I really need help

Z

zanbagh.adeli

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
 
Z

zanbagh.adeli

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
Click to expand...
https://dl.dropbox.com/u/56812294/MAJOR_s1.xlsx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
How to find duplicate column (not the cell values) 3
Excel VBA help: Text file formatting 19
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Comparing numbers 1
insert rows and copying cells in column b,c, and d into new rows 3
Best Practice for Public Variables for Column Headings 2
Combine three InputBoxes into one? 7

Top