excellent !! thanks rylo.
i still need your help to do some changes.
1. data taken from whole column of B & D (Sheet 1)
and output would be in column of A & B (Sheet 2).
2. pls have a look into errors which shown in attached image (ttik.jpg).
Thank you very much !
thanks again rylo,
still have some spacing problem. see attached.
Did you check that any trailing spaces in column D had been removed????You will have to remove the trailing space in sheet1!D2.
okay, i will remove all the spacing & commas before run the macro.
again, thanks mate !!
There are currently 1 users browsing this thread. (0 members and 1 guests)