Visual Basic / VB editor in Excel 2019 unavailable
Hi all. I'm having a problem with Excel 2019. I can't open the VB editor at all. It's unavailable or greyed out. To me, this means that there is something wrong with the installation of Office 2019. I havern't had any other problems with any other Office programs as yet as this was just installed. I use VB editor a lot and am now stranded until I can fix this problem. Please help.
ow find duplicate rows In Excel and Export Rows to another sheet using vba
How find duplicate Values In Excel and Export Rows to another sheet using vba. I had an excel sheet with multiple rows and column lets say from A to K. I need to find duplicate rows only if values in all the columns in a row are unique. And the script should ignore D,E,F columns even though those column's values are same. The script should also copy all those duplicate rows and should paste in a new excel file. Also attaching a sample image of input file. Can any one help me on this. Thanks in advance. Note: I don't need unique rows I need only duplicate rows as an output and the output should also contain source duplicated row.i need output as 2 to 7 in this scenario(picture attached). the original file has 1lac rows like this. This attached one is just reference file