Automated Row Deletion

[Askeau]

So, I've noticed reading through these forums that there appears to be a lot more functionality available through VB features and items I didn't even know Excel had the capability to complete.

I'm hoping someone can point me in the right direction to learn more about the features in general as I'm looking to add some functionality that I don't believe Excel supports in its base format.

In this instance, I'm looking to automate a search of a specific column and delete columns that don't start with a numeric value or the word Total/Totals. I'm also looking to see if I can automate hiding of rows that don't start with a numeric value. While I want to keep the "Totals" lines, I'm looking to have them hidden in the end, but they contain information I need for formatting other sections of the report I'm preparing.

If someone can point me in the right direction and potentially assist in designing something that would help me out, it would be greatly appreciated.

 

[James006]

Hi,

In my opinion, the easiest is to add a column to hold following formula:

=IF(ISERR(LEFT(A2,1)*1),"Letter","Number")

Then with AutoFiler is becomes very easy to delete all rows with Letter ...

Hope this will help