View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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?