• 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

    Hi : Have uploaded modified original file. Macro provided doesn't work for dates/times in column D. Really appreciate your help!!!
  2. I

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

    Any help Please ?? My orIginal data in column D has dates/times to compare in format (ddd mmm dd,yyyy - hh:mm AM/PM - please see my previous post
  3. I

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

    Thanks for quick reply.. Help me modify 1.My Original data is in column D and sheet named "Plan"(Sheet 3) 2. Only predefined Colors to be used provided in list and option to add more colors if reqd. 3. In your macro - Colors change on new entry for previous entries. 4. When reqd. - It's better...
  4. I

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

    Hello Found below macro to find duplicates in single column and highlight matching values, Issue with this macro is it uses only 1 color (red) and searches for duplicates in other columns Require below pre defined colors to be added in below macro and search for duplicates in only single...
  5. I

    Reminders pop up based on time input in another cell

    Thank you very much Chihiro for the code , It works perfectly for us.
  6. I

    Reminders pop up based on time input in another cell

    Thanks Chihiro for prompt reply. Understand It's ideal to use email client, However for our work nv,email client isn't feasible, Coz worksheet gets passed on to other person after his\her shift is done. So macro will assist user to intput date for last email sent and countdown should start...
  7. I

    Reminders pop up based on time input in another cell

    Hi, Is there a VBA code to pop up reminder message 15 mins before time provided in another cell and update original time after time lapse. Have attached Test file with details.
  8. I

    Fill up color on duplicate date\time in another column cell

    uploaded test file with request
  9. I

    Fill up color on duplicate date\time in another column cell

    Thanks for the macro , It makes life much easier , have around 1000 lines of data with dates\times Need minor fixes 1.After running macro and if fillup color is cleared (No fill) and macro executed again,Macro doesn't clear the filled up color in matched cell columns. 2.Forgot to add this in...
  10. I

    Fill up color on duplicate date\time in another column cell

    Searching for VBA script to do following : 1. If color filled up in Column E cell , Search and match date\time in column D and fillup with same color. excel version 2010 Note: Have other macros running on same spreadsheet for other activities
  11. I

    Find and match - Highlight Duplicates in 2 Columns

    Thanks Guys , Was able to resolve using cell.Text
  12. I

    Find and match - Highlight Duplicates in 2 Columns

    Trying to highlight with different colors for duplicate cells in excel 2010 across column D and E finding and matching date and time (Custom formated cells ddd mmm dd,yyyy - hh:mm AM/PM). I found this code but it throws out runtime error 91 : object variable or With Block variable not set. at...
  13. I

    Macro for finding duplicate ip address from each tab

    Thanks for replying.. I have to identify the sheet and row# for me to highlight and filter the duplicates out from other sheets, As mentioned - have atleast 20 sheets of data in workbook And sheet names could be named different too , not always sheet 1,sheet 2,sheet 3...
  14. I

    Macro for finding duplicate ip address from each tab

    Hello, Using excel 2010 -Need help with a macro to compare multiple tabs in spreadsheet to find duplicate ip address in all tabs and provide output in a end new tab with existing duplicate ip address found , server name associated with ip address and tab name and row number. Note:Since ip...
  15. I

    Extracting certain data from a text file to Excel using VBA or a Macro?

    Thanks..It works
  16. I

    Extracting certain data from a text file to Excel using VBA or a Macro?

    Hello, I am trying to extract certain data from a text file(Windowsupdate1) into an Excel spreadsheet. I'm using MS Office 2010 . I saved my files as TEXT formatted files and now I need to pull information from the text files.Here is a list of the information I need to extract from the text...
  17. I

    Data extraction

    Thank you so much SirBJ7...It works with some tweaking...
  18. I

    Data extraction

    yes in one cell
  19. I

    Data extraction

    hi, Need help to get a macro to extract data from column C and paste in Column c and D EXAMPLE : Coloumn C has data <html><b>04/12/13 00:44 - eocsupport:</b> Event acknowledged, ownership assigned. Reference ID associated with event. ID: 123456 </html&#62...
  20. I

    Combine data from columns into single cell [SOLVED]

    Thank you SirJB7 - Hui ..it worked
  21. I

    Combine data from columns into single cell [SOLVED]

    Aaah...iam not good with excel...if somebody cld provide a macro to join/merge data from 2 or more columns, tet separated by "_" column A Column B Column C APPLE ORANGE GRAPES OUTPUT IN COLUMN A Column A APPle_orange_grapes
  22. I

    Combine data from columns into single cell [SOLVED]

    sajan - I need to join data of complete row into single cell eliminating any spaces or tabs example : A1 B1 C1 D1 E1 F1 APPLE GRAPES ;DELTA1 BLANK :: "D2 output reqd : In COLUMN A1 AppleGRAPES;DELTA1::"D2
  23. I

    Combine data from columns into single cell [SOLVED]

    Hello , Can somebody help with this data, CSV Sheet contains data in multiple columns with spaces tabs and blank columns , needing to combine all data in single cell without any spaces or tabs. macro needed -sample file attached , usually my data runs A1 TO AU5000...
  24. I

    compare data from 2 sheets

    Aha...It works...thank u so much...SirJB7
  25. I

    compare data from 2 sheets

    hi SirJB7, Both conditions should prevail...if data in fixed sheet exists, it should capture overriding data in pre-input
Back
Top