Find cells in colum A that do not contain a number and delete their rows

So I have a document in which I need to keep only the rows that contain a number in cell 1. The placement of these cells (rows) will always vary so my (limited) knowledge of using macros will not help me for this one. I am thinking there must me a formula that says, "if cell in Column 1 does not contain a number, then delete coinciding row."

Here is what it looks like, the rows that contain numbers in cell 1 have the only data I need:
scr_report.PNG


Any thoughts?

Originally Posted by xladept

Hi K,

Try this:

Please Login or Register  to view this content.

*If there is no header then change the red number

That worked perfectly! The only row left that I didn't need was the row that contained the date, which makes sense since there is a number in it. Is there a way to take it one step further and say if the cell in Column A does not begin with a number, then delete?

thank you so much!