See attached Ojemeni Uzoma I Radio Network Planning & Optimization Engineer. HUAWEI TECHNOLOGIES 8th floor, Plot 98, Adeola Odeku Str. South Atlantic Petroleum Towers, Victoria Island, Lagos. Tel: 0806 070 0717, 0702 857 7421 Email: u...@huawei.com www.huawei.com
>From :uojemeni Date :2010-03-28 22:51:19 To :excel-macros cc:uojemeni Subject: Continuous-Selection and transpose Hello All, Pls I need your help. I would like to find "ADD NBRCDMACH"(see attached) and then select the found cell and two subsequent cells in the same column and then transpose the selection in a different column. This procedure will be repeated over and over until the find "ADD NBRCDMACH" is exhausted.The results wil be pasted in the target column line by line. A VB script will do. Thank you in advance. BR Uzoma -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.
txt.xls
Description: Binary data