I have a problem that may have a very easy solution....but buggered if I can find it (even after searching on this forum and trying to use various VBE routines that I found)
I have a spreadsheet that is thousands of rows long which describes a series of instructions.
In particular, I am only interested in rows that say "Queue to" and the associated value which will be in the range 1-250 (this will be on the very next Row, but not the same Column))
I have eliminated most of the unwanted instructions by using "Find and Replace" and now have a series of blank Rows.
Column A may have data
Column B may have data
I only want to delete the Rows where there is no data in either of the columns
Am I missing something easy ?
Bookmarks