dcsimg

Search:

Type: Posts; User: abhay_547

Search: Search took 0.02 seconds.

  1. Re: [RESOLVED] highlight duplicate rows include original instance.

    Just one last thing, it creates the duplicates sheet, even when there are zero duplicates sometimes in the sheet. can we avoid created the duplicates sheet when there are no duplicates and show a...
  2. Re: highlight duplicate rows include original instance.

    Got it. It works now. Thanks a lot. Appreciate it :)
  3. Re: highlight duplicate rows include original instance.

    Now it shows Run time error '424' Object required on the line highlighted in blue.


    Option Explicit

    Sub IdentifyDuplicatesandmovenew()

    Dim ws1 As Worksheet
    Dim Row1 As Range
    Dim Col1 As...
  4. Re: highlight duplicate rows include original instance.

    Now it shows syntax error on the updated line (highlighted in blue)



    Option Explicit

    Sub IdentifyDuplicatesandmovenew()

    Dim ws1 As Worksheet
    Dim Row1 As Range
  5. Re: highlight duplicate rows include original instance.

    Ok. I have updated the code by defining variables, but it seems something is going wrong. It shows compile error on the line highlighted in blue. Can you please help.


    Option Explicit

    Sub...
  6. Re: highlight duplicate rows include original instance.

    I tried the below but it shows errors on the lines which are highlighted in bold and blue. instead I can use the combine sheets method post running the entire macro, but I think we don't need to use...
  7. Re: highlight duplicate rows include original instance.

    It's working but it moves each original and duplicate set of rows into a separate sheet but I want all the original and duplicate set of rows to be moved into one worksheet and name it as "Filtered...
  8. Re: highlight duplicate rows include original instance.

    There were no attachments in this thread. I have a data in which I have some duplicate rows items (spanning across multiple colums) and I want to identify those duplicate row items along with...
  9. Re: highlight duplicate rows include original instance.

    can someone help with the above code.
  10. Re: highlight duplicate rows include original instance.

    Ok. Color coding is not important, I thought it makes it easy to identify the data using colors. I just need same original set of rows and same duplicate set of rows to be identified first and then...
  11. Re: highlight duplicate rows include original instance.

    Ok. got it. in that case how do i filter for both blue and red rows at one go from base data and also I don't want to hard code the filter range (highlighted in bold). can you help



    Option...
  12. Re: highlight duplicate rows include original instance.

    Great. It works now. I just need 1 more addition .i.e. to copy red or blue (either one) highlighted cells data including header (don't want to hard code the range, highlighted in bold) in a new sheet...
  13. [RESOLVED] highlight duplicate rows include original instance.

    I want all the duplicate rows highlighted in a worksheet along with original instance e.g. if I have row 1 with some data in multiple columns and the same date appears on row 20 then the macro should...
Results 1 to 13 of 13



Featured


Click Here to Expand Forum to Full Width