Hi amb2301
I think you are making this a lot more difficult then it needs to be and will be possibly wasting a lot of time unnecessarily.
I am a bit confused at what you are asking for, because you are mixing up data and requirement descriptions. You may send yourself and others trying to help you going around and around in circles.
I think you need to make a small set of test data, but think very carefully and give data which shows all possible scenarios.
You need to give very clearly in words what you want.
You need to show clearly what you want
You will possibly know what you want. But I am confused. Possibly you yourself do not yet understand what is required. For example****
You say that the green highlighted cells are working fine with existing script ??? – Is that correct ?? – take a look: Here is a sample of your supplied data, which is produced from your existing script:
https://excelfox.com/forum/showthrea...ll=1#post13380
Those results are all mixed up!!
This could mean anything ..” if single Numberical value (1,2,3.4,5,6,7,8,9) comes in C column,it should be moved to the D column
by adding text like(1st,2nd,3rd,4th,5th,6th,7th,8th,9th).”….
Of course, you will understand that. You will understand that because you know what you want.
For anyone else , it can mean lots of things.
If you still want help with this, I can take another look again here tomorrow.
If you want my help you must explain and show clearly what you want.
You must give a small amount of rows that show every possible scenario. You must explain clearly what you want. And you must manually write in the results as you want them correctly to be done by the macro.
It is impossible to know what you want, since the results of the script, which you say works for the green highlighted cells, is producing rubbish.
I don’t think this is a difficult problem to solve. But you have not yet explained clearly what you want.
Nobody, except you, can know what you want. ( Or worse... you may also not yet know what you want)
Alan
P.S****Do you know that in English language, Direction is not just
N,E,S,W
It is
N,NE, E,SE, S,SW,W,NW
This is one reason why your results highlighted in green are rubbish
_____ Workbook: address sheet.xlsm ( Using Excel 2007 32 bit )
Worksheet: Sheet1
Row\Col A B C D E F G 1Address Door# Direction street name roadtype street name + roadtype City Name 11 102 11 AVE S 102S 11AVE 12 10205 134 AVE NW 10205134 AVE NW
Bookmarks