Copying Partial Workbook To Another Workbook

[Diane]

I want to take information from an existing action item workbood and populate another workbook. Basically, I'm looking to put an equation in the destination workbook something like


IF(workbook D column A row 1 = 4 then populate workbook F with line 1 of existing workbook #4 data, "")


Any ideas?

 

[Luke M]

Would this work?

=IF([Book1.xls]Sheet1!$A$1=4,[Book1.xls]Sheet1!A1,"")

Copy to the right as far as would be needed.


Note that this formula is probably easier to build/write with both workbooks open and just clicking on the cells of interest.

 

[Diane]

Thanks Luke. I need the entire row copied to destination workbook if this formula is true. This is hard to explain....


=IF([Book1.xls]Sheet1!$A$1=4,[Book1.xls]ENTIRE ROW,"")

 

[Luke M]

IF you copied the formula to the right, it would display cell B1, then C1, then D1, etc. You can copy all the way across the row if you really want.

 

[Diane]

Here is what I did


IF('[Action_Item_Matrix.xlsm]ACTION MATRIX'!$B$3=1,'[Action_Item_Matrix.xlsm]ACTION MATRIX'!$A$3:$M$3,"CRAP")


The destination cell is now just a 1.


Maybe I can explain it differently. I have workbook A and Workbook B. Workbook A has all of the data in it, North, South, East, West. In workbook B I only want all of the North information only.

 

[Luke M]

In destination workbook, select cells A3:M3, with A3 being the active cell. Input this formula:

=IF('[Action_Item_Matrix.xlsm]ACTION MATRIX'!$B$3=1,'[Action_Item_Matrix.xlsm]ACTION MATRIX'!A3,"CRAP")

Now, to confirm formula, hit Ctrl+Enter.

 

[Diane]

Luke,


Now Cell A3 in my destination sheet is 1. I feel like if I could explain better you would be able to help me.


I want all line items in my Action Item Matrix where colum B = 1 to populate my destination workbook.