| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking workbook info to excel calendar | Excel Discussion (Misc queries) | |||
| How do I set up a workbook that the worksheets update info | Excel Worksheet Functions | |||
| Sharing Workbook Info message ? | Excel Discussion (Misc queries) | |||
| How can I link one cell to a list of info in another workbook? | Excel Discussion (Misc queries) | |||
| How do you find info in a workbook? | Excel Discussion (Misc queries) | |||
Linear Mode
