SOLVED

Question related to Remove Duplicate with the help of VBA code

%3CLINGO-SUB%20id%3D%22lingo-sub-2335413%22%20slang%3D%22en-US%22%3EQuestion%20related%20to%20Remove%20Duplicate%20with%20the%20help%20of%20VBA%20code%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2335413%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Everyone%2C%3C%2FP%3E%3CP%3EI%20have%20a%20data%20like%20-%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%20(2986).png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F279094i3A15CB3BBDA00E52%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%20(2986).png%22%20alt%3D%22Screenshot%20(2986).png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EIn%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3Eevent%20id%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3Brow%20some%20id%20are%20repeated.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ESo%2C%20In%20above%20image%2C%20At%20A8%20there%20is%20event%20id%2085612%20but%20in%20A9%20also%20event%20id%20is%2085612.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3Eso%20i%20want%20to%20delete%20the%20entire%20row(Blank%20row)%20in%20this%20sheet.%20And%20Many%20repeated%20blank%20row%20is%20there.%20So%2C%20i%20want%20to%20remove%20with%20the%20help%20of%20VBA%20code.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ESo%2C%20what%20VBA%20code%20should%20i%20write%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EPlease%20help...%3F%3F%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2335413%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2335669%22%20slang%3D%22en-US%22%3ERe%3A%20Question%20related%20to%20Remove%20Duplicate%20with%20the%20help%20of%20VBA%20code%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2335669%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F811137%22%20target%3D%22_blank%22%3E%40Zan_Hanifee%3C%2FA%3E%26nbsp%3BConsider%20Power%20Query.%20no%20need%20for%20VBA.%20Connect%20to%20the%20data%2C%20promote%20headers%20and%20filter%20out%20%22null%22%20from%20the%202nd%20column%2C%20close%20and%20load%20back%20to%20Excel.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2335687%22%20slang%3D%22en-US%22%3ERe%3A%20Question%20related%20to%20Remove%20Duplicate%20with%20the%20help%20of%20VBA%20code%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2335687%22%20slang%3D%22en-US%22%3ECan%20you%20please%20explain%20with%20the%20help%20of%20a%20Screenshot%3F%20Please%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2335736%22%20slang%3D%22en-US%22%3ERe%3A%20Question%20related%20to%20Remove%20Duplicate%20with%20the%20help%20of%20VBA%20code%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2335736%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F811137%22%20target%3D%22_blank%22%3E%40Zan_Hanifee%3C%2FA%3E%26nbsp%3BScreenshots%20are%20quite%20meaningless%20in%20this%20context.%20Can%20you%20upload%20a%20file%20with%20the%20first%2025%20rows%20or%20so%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Regular Contributor

Hello Everyone,

I have a data like - 

Screenshot (2986).png

 

In event id row some id are repeated.

So, In above image, At A8 there is event id 85612 but in A9 also event id is 85612.

so i want to delete the entire row(Blank row) in this sheet. And Many repeated blank row is there. So, i want to remove with the help of VBA code.

 

So, what VBA code should i write?

 

Please help...???

 

 

 

 

6 Replies
best response confirmed by cuong (Microsoft)
Solution

@Zan_Hanifee Consider Power Query. no need for VBA. Connect to the data, promote headers and filter out "null" from the 2nd column, close and load back to Excel.

Can you please explain with the help of a Screenshot? Please

@Zan_Hanifee Screenshots are quite meaningless in this context. Can you upload a file with the first 25 rows or so?

Sir! We can do like this -
1st step - On the Home tab, in the Editing group, click Find & Select.
2nd step - Click Go To Special.
3rd step - Select Blanks and click OK. Then, Excel selects the blank cells.
4th step - On the Home tab, in the Cells group, click Delete.
5th step - Click Delete Sheet Rows


Is this correct?

@Zan_Hanifee Yeah! that seems to work as well.

 

Thank you so much sir for helping and motivate me