When you need to delete records based on a single value in Microsoft Excel, use this Visual Basic procedure. It can make your life a lot easier.

Open the Excel 2010 worksheet that contains the rows you want to delete. Press "Alt+F11" to launch the VBA code editor. Right-click on the name of your current worksheet, which is listed on the ...

Excel Online doesn’t support VBA. ... If Personal.xlsb is in the Project Explorer, ... Double-click Module1 to open its code sheet and delete the procedure you just created.