Monday, September 26, 2016

Delete rows based on condition ( Automate the process, if possible) Tech Support

Delete rows based on condition ( Automate the process, if possible)

Hello,

I have an excel sheet with around 15,000 rows and about 20 columns.

I am comparing values in M and N to display the contents of M in column O, if values in the N (reference column) is present anywhere in M.

I want to DELETE all those rows with an empty O column.
Since I have many rows, it will take a long time to delete manually. 

Can anyone help me on how to automate this using some functions/VBA script?

Thanks you

Kart

Solutions to the Problem Delete rows based on condition ( Automate the process, if possible)

Download Error Fixer for Free Now

I assume that your O column is just a bunch of formulas that return blank or the value form M and you want to delete the blanks? If so then here is some code that delete blanks in column O on the acitve sheet:
 
Public Sub DeleteBlankO()
    Dim rngAll As Range
    Dim rng As Range
    Dim rngToDelete As Range
   
    Set rngAll = ActiveSheet.Range("O:O").SpecialCells(xlCellTypeFormulas)
   
    For Each rng In rngAll
        If rng.Value = "" Then
            If rngToDelete Is Nothing Then
                Set rngToDelete = rng
            Else
                Set rngToDelete = Union(rng, rngToDelete)
            End If
        End If
    Next rng
    If Not rngToDelete Is Nothing Then rngToDelete.EntireRow.Delete
End Sub

Note: It is recommended that you back up your files and folders before attempting this step:

  • Move the mouse cursor over to the upper right side of the screen.
  • A menu will pop up on the left. Click on the "Settings" feature on the menu.
  • On the Settings window, click on the "Change PC settings."
  • Now, left click on the "Update and recovery" feature.
  • For the next step, left click on the "Recovery" feature.
  • There is an option here saying "Refresh your PC without affecting your files." There, left click on the "Get started" button.
  • Now, follow the instructions on the screen to finish the Refresh process.
  • After the Refresh process has finished restart your Windows 8.1 or Windows 8 device.
  • Check again to see if the error Delete rows based on condition ( Automate the process, if possible) has been fixed.

If you do not possess the technical expertise required to accomplish this yourself or do not feel comfortable doing so, download and install a powerful automated tool to get the job done.

Recommended Method to Fix the Problem: Delete rows based on condition ( Automate the process, if possible):

How to Fix Delete rows based on condition ( Automate the process, if possible) with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your system.  Open it, and it will perform a scan for your computer. The junk files will be shown in the scan result.

2. After the scan is done, you can see the errors and problems which need to be repaired.

3. The Fixing part is finished, the speed of your computer will be much higher than before and the errors have been removed.


Related: How to Update & Download NVidia GeForce 6100/nForce 420 WHQL Certified driver v.178.13,How to Update & Download NVidia GeForce 7600 GS Video Driver v.295.75 Certified,How Can I Update & Download NVidia GeForce 820M Driver v.344.48 WHQL,[Solved] Download NVidia GeForce GTX 560M VGA Driver v.296.17 Certified,Way to Update & Herunterladen NVidia GeForce GT 130M Video Treiber v.295.75 Certified,How to Update & Download SONY SVE14A1X1RH Realtek Ethernet Driver,Where to Download SONY SVS13A2W9ES Bluetooth Driver (Intel) v.2.6 - 2.6.23.40059,Best Way to Update & Download SONY VGN-CR203E Conexant HDAUDIO SoftV92 Data Fax Modem with SmartCP Setup Program v.7.62.0.50 driver,Best Way to Download SONY VGN-FE790G/N Wireless LAN Driver v.10.6.0.29,Method to Update & Download SONY VGN-NR31Z/S Firmware Extension Parser Device v.8.0.2.3,How to Fix Error 0x0000c1f5 SoluciĆ³n?,Error 0x80071a91 Win7 Fix Patch,Error 0x800ccc60 Windows Live Mail [Solved],Error Message 0x800ccc79 Outlook 2000 Fix,What is Error 0xc1ab0001?,[Answered] x64 saplugin dll,How to Fix Problem - Kb943729 Download?,Troubleshooting: Bccode D1 Error,Java Runtime Tech Support,Troubleshooting: ERROR NO SUCH GROUP Error
Read More: Solution to Error: Delete module in VBA Excel ?,Troubleshooting:cyberlink program will not unistall, it says setup cannot load/unload UNO.dll,Cut down Win 7 after System Image restore to new HDD,How to Resolve - Dell computer newly upgraded to windows 7 / 32 from XP freezes up for 30-50 seconds while browsing?,Troubleshooter of Error: Dell Inspiron n7110 graphics and gaming graphics problems and screen resolution problems

No comments:

Post a Comment