• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. P

    Macro coding need for arranging a code

    Hi Narayan, Thanks for your timely help....Please share ur id if u r in gtalk or yahoo messenger.
  2. P

    Macro coding need for arranging a code

    Hi Narayan, Code is working fine now with some small modification.Now it fulfilled my requirement. Please find the modified code below. Application.ScreenUpdating = False Start_Range = "A2" End_Range = "E501" ThisWorkbook.Worksheets("Sheet1").Activate Range(Start_Range...
  3. P

    Macro coding need for arranging a code

    If I understand you correctly , you have added one more column in your raw data , which contains Code3. Where do you want this to appear , in Sheet2 ? In column B ( in the second row ) or in the third row for each entry ? I want to place code_Text1 to appear in column C2,Code_Text3 in C3 and...
  4. P

    Macro coding need for arranging a code

    Hi Narayan...VGM I need to add up one more line along with this code...pls help i tried to do it myself to max but it's not working out. Application.ScreenUpdating = False Start_Range = "A2" End_Range = "E501" ThisWorkbook.Worksheets("Sheet1").Activate Range(Start_Range...
  5. P

    Macro coding need for arranging a code

    Thanks Naryanan...it's fulfilled my requirement....You are man of logic...Thanks a ton :)
  6. P

    Macro coding need for arranging a code

    yeah narayan,you are right S.no in A2,Ip in B2,edittext in c2 and subnet text in d2.
  7. P

    Macro coding need for arranging a code

    Hi Narayan, Entries is in 3 different columns Starts from A2 to C2 in sheet1. I want that entires in sheet 2 as In A2 column of sheet 2 should contain 221.135.254.168 subsequently in B2 column -edit "221.135.254.168",in b3 column-set subnet 221.135.254.168 Then next 221.135.254.169 in A4...
  8. P

    Macro coding need for arranging a code

    Friendz...Good morning to all I need a macro coding for the below requirement. I have a entries in a continuous rows in sheet1 as like below S.no IP Code1 Code2 1 221.135.254.168 edit "221.135.254.168"         set subnet 221.135.254.168...
  9. P

    Reversing a Text using Formula

    Thanks for all your posts :)
  10. P

    Reversing a Text using Formula

    Or otherwise do we have formula to reverse a line of text as like below Orginal text:Third Floor Rajwada Chowk Change to:Chowk rajwada floor third. Will that be possible with formula or do we need to go for macro?...kindly suggest Note:I just given the sample line,it has characters more...
  11. P

    Reversing a Text using Formula

    Hi, I have a text called Ibrahimpatnam in need to reverse this text as mantapmiharbi using a formula.Please suggest me the formulas to derive the solution. Ps:No macros please.
Back
Top