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

    Macro to fill up pre defined colors for duplicates in single column

    @Nebu ...Dates and times are very often changed, Your solution doesn' if date or time is changed and new dups found
  2. I

    VBA for searchable dropdown

    Excel wizards - Need on a macro to perform a searchable drop down list (Like google , Type in T in a cell dropdown shortlist starting with "T" or "club" shortlist club from list IN Colum A and same with groups dropdown(Col C), Have long list in dropdrown items and its difficult to pick by...
  3. I

    VBA to split fullname to first and last and clean any trailing spaces

    @shrivallabha ..Thank u for providing solutions. You guys are the best.
  4. I

    VBA to split fullname to first and last and clean any trailing spaces

    @ jindon ..Thanks so much..it works for just single name..
  5. I

    VBA to split fullname to first and last and clean any trailing spaces

    @shrivallabha ..Tried your code on back up , It wiped out my data in (4. mobile) above D18 and other columns in (4.mobile), didnt see names split.
  6. I

    VBA to split fullname to first and last and clean any trailing spaces

    Works fine if full name is entered , Gives "run time error type mismatch 13" on highlighted in RED, when just firstname is entered. If no spaces or just single(first\lastname) entered in Column "c" ,should copy to First name column D in Tab (4. Mobile) Really Appreciate your work.... Private...
  7. I

    VBA to split fullname to first and last and clean any trailing spaces

    @jindon..Thank you much ...awesome..works like a charm.
  8. I

    VBA to split fullname to first and last and clean any trailing spaces

    when copied to another spreadsheet ,Getting "Run time error Type-mismatch 13" and stops at highlighted RED Any suggestion?? Private Sub Worksheet_Activate() Dim a, i As Long, e Application.EnableEvents = False a = Sheets("2. Planning").Columns("c").SpecialCells(2).Value With...
  9. I

    VBA to split fullname to first and last and clean any trailing spaces

    Thank you @jindon ...works well...
  10. I

    VBA to split fullname to first and last and clean any trailing spaces

    @ Jindon...Your code works well but not on my worksheet , which had data validations..Kindly have a look at the latest attached file.
  11. I

    VBA to split fullname to first and last and clean any trailing spaces

    uploaded original file ... Above code doesn't run original file tab 2.planning fullname to be split first last name
  12. I

    VBA to split fullname to first and last and clean any trailing spaces

    And please suggest how do i combine those 2 codes?
  13. I

    VBA to split fullname to first and last and clean any trailing spaces

    It works on my backup sheet.. Having problem with my orginal sheet. Running another code on (2. Planning) tab for to select mutiple items from dropdown list in column C (see below code) Getting error message ambigous name Private Sub Worksheet_Change(ByVal Target As Range) Dim rngDV As...
  14. I

    VBA to split fullname to first and last and clean any trailing spaces

    Excel wizards need macro help on splitting fullname to seperate columns (Firstname and lastname) from (2. planning) tab and copied to (4. mobile) tab in column D and F from line 18, Need to clean any trailing spaces,If name seperated by semicolon,second name to be copied in next row and Delete...
View older results
Back
Top