Printing into another workbook.

[jrg_1411]

Hi, I have a feeling this may be out there somewhere, but after extensive searching, I can't find it.

I want to use VBA to print cells into another workbook in the same way that you can print into another sheet in the same workbook using code similar to this:

(For example if I wanted to print the first 3 columns in that row each time there was information about Sydney)

If Sheet1.Cells(1, 1) = Sydney Then

Sheet2.Cells(1, 1) = Sheet1.Cells(1, 1)
Sheet1.Cells(1, 2) = Sheet1.Cells(1, 2)
Sheet1.Cells(1, 3) = Sheet1.Cells(1, 3)

End If

Note that I do not want to copy paste, or to link the cells, which are possible through excel.
I have thousands of cells and I want VBA to search through them and when it finds a match for my criteria, to take the value in Workbook("Book1.xlsx") that I am searching in, and then for that information to be printed to Book2.xlsx.

Any help would be much appreciated

 

[jrg_1411]

Sorry, the middle bit should read

Sheet2.Cells(1, 1) = Sheet1.Cells(1, 1)
Sheet2.Cells(1, 2) = Sheet1.Cells(1, 2)
Sheet2.Cells(1, 3) = Sheet1.Cells(1, 3)

not that this code is directly what I want to do, just an example