• 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. bevg1971

    vba- how to use vlookup(concatenate) function.

    Hi Hui, thank you for the information... the header is included in case a report/pivot needs to be created by the end user. I have attached the excel file. i have no idea how to write the code to do the vlookup... do you have any existing make that i can edit to make it work with my data?
  2. bevg1971

    want to use VBA for applying concatenate and vlookup to transfer comments from one file to another

    I am sorry Luke. i will do that... thank you for the information.
  3. bevg1971

    vba- how to use vlookup(concatenate) function.

    I don't know how to use the vlookup(concatenate) function using bva. I need to use the values in column b and column c. then I need to go to the list in i2:j3 (or this list can be located in sheet2) to match the values which have been concatenated. Then i need to copy and paste the result in...
  4. bevg1971

    Do not be anxious about tomorrow.

    Do not be anxious about tomorrow.
  5. bevg1971

    If cell equal to a value copy the row and the row above into

    thank you for the reply... i was not notified about this response...
  6. bevg1971

    want to use VBA for applying concatenate and vlookup to transfer comments from one file to another

    Hi, here is a sample of the data, I don't know how to use the vlookup and concatenate function in VBA. I need to place the result in E2. read some example but the code gets too complicated... i need to keep it clean and simple. thanks!!
  7. bevg1971

    Hello .. Introduce yourself

    Hi to all, i am very new to vba, so I am looking forward to learning from this forum. thank you in advance!! Regards, Byron.
  8. bevg1971

    If cell equal to a value copy the row and the row above into

    I need to a code vbs in excel that will find an specific value (TI), copy the row with the value and the row above, and paste into a new worksheet, then it needs to loop back and find the next instance and do the same task. 5209845561ab u m aaa-aaa HU CI 4/19/2013 21:24 4/19/2013 21:24...
Back
Top