Select and rows to another cell if one of the cells contains data
 

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

Select and rows to another cell if one of the cells contains data
 

Try Data | AutoFilter to see if you can select just that data
Copy it to target
If this works, just record a macro of the steps you used
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"schleprock" wrote in message
...
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

Select and rows to another cell if one of the cells contains d
 

All the columns after A are also the months of the year that the isues were
reported. I have something similar to that now but I was looking to automate
more of it if possible. The cells that I am copying the data to will provide
the information for monthly graphs. I would pull the data directly from the
original location but that data is in a pivot chart and I can not munipulate
the data the way that I need to for graphing.


"Bernard Liengme" wrote:

Try Data | AutoFilter to see if you can select just that data
Copy it to target
If this works, just record a macro of the steps you used
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"schleprock" wrote in message
...
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