I have an excel sheet that has 11 columns just as follows:
<tbody>
</tbody>
I am wanting to create a macro that will either automatically delete or a macro I can create a button to initiate that will delete every row that has a 0 in columns H (Inv), I (Sales) and (Sales2nd). A 0 has to appear in ALL THREE columns in order for me to want to delete it.
My rows will only go up to row 2500.
I am very much so a beginner when it comes to macros and have only had success so far with sorting and deleting specific numbers of rows. So if anyone can help me get gain a little bit more knowledge that would be great! Thanks for all your help in advance!
PLU | Description | Dept | UOM | Cost | Retail | Margin | Inv | Sales | Sales2nd | Supply |
12345 | Jack Dan | 135 | 750 | 1.11 | 1.99 | 22.14 | 0 | 0 | 0 | 0 |
20151 | Cuervo | 136 | 750 | 1.13 | 1.99 | 22.51 | 3 | 1 | 1 | 3 |
50364 | Jim Beam | 136 | 175 | 1.43 | 2.49 | 22.54 | 0 | 0 | 0 | 0 |
<tbody>
</tbody>
I am wanting to create a macro that will either automatically delete or a macro I can create a button to initiate that will delete every row that has a 0 in columns H (Inv), I (Sales) and (Sales2nd). A 0 has to appear in ALL THREE columns in order for me to want to delete it.
My rows will only go up to row 2500.
I am very much so a beginner when it comes to macros and have only had success so far with sorting and deleting specific numbers of rows. So if anyone can help me get gain a little bit more knowledge that would be great! Thanks for all your help in advance!