What exactly i need is 1. To extract the active route column in column a having a len value (character
count) [if>8 repeate only once][if>16 repeate twice] to duplicate its value in the next immediate row i.e green rows [like cell a34] as shown in the cells below. 2. To extract the sectors and loads from column f to column g and h as shown in th cells below. Thank you all.
Doing this with standard formula will be long winding.
Ask modertor to move this post to VBA section.
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
Thread moved to programming subforum.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks