Hello All,
I am looking for a macro to concatenate K% and L% into M% for every row which column K has data.
I have attached a spreadsheet to serve as an example. Column M represents the final output.
Thanks in advance!
Hello All,
I am looking for a macro to concatenate K% and L% into M% for every row which column K has data.
I have attached a spreadsheet to serve as an example. Column M represents the final output.
Thanks in advance!
Last edited by tiger10012; 10-12-2011 at 11:24 AM.
With the information you have provided
In M2
Drag/Fill Down.![]()
=(K1*10)+L1
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
But if you must do it with code..
![]()
Sub a() Dim rCell As Range For Each rCell In Range(Range("K1"), Range("K" & Rows.Count).End(xlUp)) If rCell.Value <> "" Then rCell.Offset(0, 2).Value = rCell.Value & rCell.Offset(0, 1).Value Next End Sub
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Thanks so much to both of you. This is great.
sweep...thanks for following up with the code. This is something I have been dying to incorporate into my other existing macros for quite some time.
Cheers!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks