I was wondering if it was possible to select and copy multiple rows if there
is data in one of the columns.

Application (Column A) Number of issues (column B)
Access 3
Access Manager 2
Adober Acrobat
Adobe Acrobat Pro 1
Business Objects 2
CITRIX
ExpenseLink 2

For example I have application names in Column A and a number of issues
reported per application in column B. All cells in column A contain
application names but not all cells in column B contain a number of
application issues. I would like to only copy the applications and the # of
issues for the rows that have a number of issues. I would like to be able to
have something like this

Application (Column A) Number of issues (column B)
Access 3
Access Manager 2
Adobe Acrobat Pro 1
Business Objects 2
ExpenseLink 2

Can this be done through a Macro or VB code? TIA

Thanks,
Eric