Certain info from one workbook to another
 

I have a Workbook A. I want to take certain rows and display them in order
in Workbook B.

The rows have 25 columns. If I take all rows that have 302 in Column B how
can I display those row contents in an entirely different workbook just
containing 302 info?

Certain info from one workbook to another
 

DataFilterAutofilter for 302 on Column B

Copy and paste the visible results to the other workbook.


Gord Dibben MS Excel MVP

On Wed, 18 Apr 2007 14:10:02 -0700, ihatetheredskins
wrote:

I have a Workbook A. I want to take certain rows and display them in order
in Workbook B.

The rows have 25 columns. If I take all rows that have 302 in Column B how
can I display those row contents in an entirely different workbook just
containing 302 info?

Certain info from one workbook to another
 

"Gord Dibben" wrote:

DataFilterAutofilter for 302 on Column B

Copy and paste the visible results to the other workbook.


Gord Dibben MS Excel MVP

On Wed, 18 Apr 2007 14:10:02 -0700, ihatetheredskins
wrote:

I have a Workbook A. I want to take certain rows and display them in order
in Workbook B.

The rows have 25 columns. If I take all rows that have 302 in Column B how
can I display those row contents in an entirely different workbook just
containing 302 info?

Yes, I can do this. But is there a way that it can be automated with a formula instead of manually doing this?

Certain info from one workbook to another
 

Turn on the macro recorder and record yourself filtering, copying visible cells
and pasting to another workbook.

You will get something like this.

Sub Macro3()
'
' Macro3 Macro
' Macro recorded 04-19-2007 by Gord Dibben
'

'
Columns("A:F").Select
Selection.AutoFilter
Selection.AutoFilter Field:=3, Criteria1:="1Night"
Selection.SpecialCells(xlCellTypeVisible).Select
Selection.Copy
Workbooks.Open Filename:= _
"C:\program files\microsoft office\exceldata\copyfilter.xls"
ActiveSheet.Paste
Application.CutCopyMode = False
Range("A1").Select
End Sub


Gord

On Thu, 19 Apr 2007 07:56:01 -0700, ihatetheredskins
wrote:



"Gord Dibben" wrote:

DataFilterAutofilter for 302 on Column B

Copy and paste the visible results to the other workbook.


Gord Dibben MS Excel MVP

On Wed, 18 Apr 2007 14:10:02 -0700, ihatetheredskins
wrote:

I have a Workbook A. I want to take certain rows and display them in order
in Workbook B.

The rows have 25 columns. If I take all rows that have 302 in Column B how
can I display those row contents in an entirely different workbook just
containing 302 info?

Yes, I can do this. But is there a way that it can be automated with a formula instead of manually doing this?