• 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 capture email sent datetime in excel

    Thanks luke.. Will try later tonite and will keep u informed.
  2. I

    Macro to capture email sent datetime in excel

    Arrgh..Messing it up.. Please help..Using selection code below..rows are highlighted to send email, So need to fillup info colum M once email is sent with text"email sent" and time.. Dim thissheet As String thissheet = ActiveSheet.Name Dim head As Range Dim rng As Range Set...
  3. I

    Macro to capture email sent datetime in excel

    Thanks for Hint..Figured it out.
  4. I

    Macro to capture email sent datetime in excel

    Different activities in rows - Sending mail for each one. ex. Select row 5 activitity - send email to group of ppl at provided time select row 6 activitity - send email to another group of ppl at a different time....and so on All activities on same sheet.
  5. I

    Macro to capture email sent datetime in excel

    Cool... Can it capture date\time and text after email being sent. With Above code..It changes to "email sent" and "date/time" as the email in draft after selecting rows in spreadsheet.Sometimes employees create draft earlier than actual time email suppose to send. Also, There's multiple rows...
  6. I

    Hello Khalid, Please have a look at this post...and need your expertise...

    Hello Khalid, Please have a look at this post...and need your expertise. http://chandoo.org/forum/threads/insert-data-at-end-of-list-in-other-sheet.28944/#post-173348
    • IKHAN
    • Profile post
  7. I

    Macro to capture email sent datetime in excel

    Hi, Can email sent thru excel spreadsheet capture "date/time and write text" in 2 separate columns. Column M text " Email sent" and Column K"ddd mmm dd, yyyy - hh:mm AM/PM" Thanks in advance
  8. I

    Insert data at end of list in other sheet

    Any name added after ; in column C in 2.planning should be added end of row in 4.mobile column D and E and any name removed in column C should delete entire row in 4 .mobile . Hope have explained it properly .. Attached sample sheet
  9. I

    Insert data at end of list in other sheet

    @jindon Hi Jindon..Welcome back.. Need help with your code provided previously ..
  10. I

    Insert data at end of list in other sheet

    @Hui .. please advise on above code
  11. I

    Insert data at end of list in other sheet

    Need help with code below - 1.If any new name is added to pre existing data or new entry in column C (2.planning) to always add to end of list in col D and E Sheet (4. mobile) 2.If data deleted from sheet(2. planning) column C -must delete complete row in sheet (4. mobile) see attached...
  12. I

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

    It's D and E column not F
  13. I

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

    Slight modification is reqd. on below code - Based on name in column D and F in "2. mobile" info is pulled from other sheet thru formulas/ vlookup and fillup data in row or info entered manually if missing against the name in the row. Above Macro is entering name correctly, but deletes any...
  14. I

    vba to extract data from GAL outlook 2010

    Sure did..Based on your instruction made changes.
  15. I

    vba to extract data from GAL outlook 2010

    Thanks Hui ...Was able to pull data from GAL
  16. I

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

    Guys.. Any suggestion.. Above code is almost there.just need minor tweaks. Any change in column d ( enter new data, change thru another cell)in planning tab should re evaluate col D and update fill colours for dups in column d
  17. I

    vba to extract data from GAL outlook 2010

    Need help - Found a macro on another site and works well to pull users and email address, However require more info to be pulled from global address list. First Name,Last Name,Department,Job Title, Business Phone,Mobile Phone,Account,email Display Name and Sort by First Name and to delete any...
  18. I

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

    Entering data in "2. planning" in column D manually and also through formula Column D = (=D13 or D14 or D15) and also noticed that when duration changes in Column F and date\time changes ,it doesn't reevaluate column D and highlight duplicate accordingly. See attached sample test file
  19. I

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

    oops forgot to include testfile
  20. I

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

    Uploaded file Please see tab 2 , 3 ,4 To highlight dups in column D from line 13 in sheet 2 and sheet 3 column D
  21. I

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

    @ Jindon ..Was able to run earlier code provided successfully...I have few rows Highlighted row 1 to row 3 and when code executed ..it clears highlights in column D. 1. Can i maintain those highlighted rows ( row1 to row 3)? 2.Have same info in another tab in column D,can his be highlighted too...
  22. I

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

    @jindon Code is in 4 .mobile as suggested, It doesn't work...see attached.
  23. I

    VBA for searchable dropdown

    @Chihiro .. Couldn't figure it out .. need searchable drop down for c1r1,c1r2,c1r3.....
  24. I

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

    Oops meant @jindon ..msg above
  25. I

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

    @Nebu ..Have another worksheet change macro running in same tab, How do i combine both to run. please see attached Macro currently running below: Private Sub Worksheet_Change(ByVal Target As Range) Dim rngDV As Range Dim oldVal As String Dim newVal As String If Target.Count > 1 Then GoTo...
Back
Top