How can I delete a row based on Columns H and I

I

ICSAnalyst

::*Hi I would like to write an EASY macro on how to delete an entire ro
if its column H and I both equal zero. Row 12 is my header row. th
macro needs to be looped until the A column has a blank cell. I a
having serious trouble. I tried looking at other macros to interepre
the logic, but i am having serious issues with the terminology in VBA
I know its easy..but I can't grasp.

I appreciate all help. Thanks*:
 
R

R.VENKATARAMAN

try this with small exstract of your data
this may not require macro

highlight whol data base including headers
clikc data-filter-autofilter
filter H column for 0
again filter I colum for 0
you will get only those rows having H and I zero
select these rows and cick edit-deleterows
now click data-filer -autofilter , that means autofilter is removed
do you get what you want.

on these steps create a macro.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top