excel vba - Macro to merge cells from two columns -

-

i create macro merges cells in column cell in column b if there data in column a. please help

do need this? assumed columns , b filled , concatenated values cells , b in cell a.

sub concatenate() dim row integer range("a1").select row = 0 until activecell.offset(row, 0).value = ""     activecell.offset(row, 0).value = activecell.offset(row, 0).value + activecell.offset(row, 1).value     row = row + 1 loop end sub

Comments

Post a Comment

Popular posts from this blog

c# - Sort XmlNodeList with a specific Node value -

-
i searched web this, not able find related solution. i have following xml <table> <entity>employee</entity> <entityid>2786</entityid> <goal> <goalid>31931</goalid> <filterdata>lastmodifiedon¥2014-03-20t18:11:01.0000000+05:30Æactivetaskcount¥0</filterdata> </goal> <goal> <goalid>31932</goalid> <filterdata>lastmodifiedon¥2014-03-22t15:26:09.0000000+05:30Æactivetaskcount¥0</filterdata> </goal> <goal> <goalid>31932</goalid> <filterdata>lastmodifiedon¥2014-03-22t09:25:00.0000000+05:30Æactivetaskcount¥0</filterdata> </goal> </table> from above xml when read data got 2 separate datatables ; 1 employees , 1 related goals. what needed want sort goals related employee respect lastmodifiedon filterdata node. note: getting lastmodifiedon value split node value this ...
Read more

Android Java.Lang.RuntimeException : Unable to start activity Component Info -

-
i'm new in android programmer. recently, trying make project using google map v2 in android app, i'm getting lot of error (i have add google play services library , find similar topic in here, not solved problem).please see log cat bellow : updated 03-22 13:52:29.331: e/androidruntime(17708): fatal exception: main 03-22 13:52:29.331: e/androidruntime(17708): java.lang.runtimeexception: unable resume activity {com.yai.testmap/com.yai.testmap.mainactivity}: java.lang.nullpointerexception 03-22 13:52:29.331: e/androidruntime(17708): @ android.app.activitythread.performresumeactivity(activitythread.java:2613) 03-22 13:52:29.331: e/androidruntime(17708): @ android.app.activitythread.handleresumeactivity(activitythread.java:2641) 03-22 13:52:29.331: e/androidruntime(17708): @ android.app.activitythread.handlelaunchactivity(activitythread.java:2127) 03-22 13:52:29.331: e/androidruntime(17708): @ android.app.activitythread.access$600(activitythread.java:140) 03-22...
Read more

php - htaccess subdomain and directory redirect -

-
i need redirect wildcard subdomain option trailing information 2 separate php variables. so example. http://company.domain.com/xyz needs go to http://domain.com/redirect.php?url=xyz&user=company i using short url redirector, , using following htaccess commands: rewritecond %{request_uri} ^(.+)\!$ rewriterule ^(.*) stats.php?url=$1 [l] rewritecond %{request_uri} ^(.+)\~s$ rewriterule ^(.*) stats.php?url=$1 [l] rewritecond %{request_uri} ^(.+)\~q$ rewriterule ^(.*) generate_qr.php?url=$1 [l] rewritecond %{request_uri} ^(.+)\~p$ rewriterule ^(.*) preview_url.php?url=$1 [l] rewritecond %{request_uri} !^(.+)\.html$ rewritecond %{request_uri} !^(.+)\.htm$ rewritecond %{request_uri} !^(.+)\.php$ rewritecond %{request_uri} !^(.+)\.js$ rewritecond %{request_uri} !^(.+)\.css$ rewritecond %{request_uri} !^(.+)\.jpg$ rewritecond %{request_uri} !^(.+)\.png$ rewritecond %{request_uri} !^(.+)\.gif$ rewritecond %{request_uri} !^(.+)\.swf$ rewritecond %{request_uri} !^(.+)\.xml$ rewr...
Read more