I'm trying to paste info from one workbook to another, but don't kno
much about writing macros. I'm just adjusting another macro to do wha
I need it to do. Here is the working macro I have so far:

Dim Markone As String
Dim Marktwo As String
Dim Markthree As String
Dim Markfour As String
Dim Markfive As String
Dim NewRow As String

Markone = Range("A12").Value
Marktwo = Range("A13").Value
Markthree = Range("A14").Value
Markfour = Range("A15").Value
Markfive = Range("A16").Value

With Worksheets("GIRDER")
.Cells(12, 1).Value = Markone
.Cells(14, 1).Value = Marktwo
.Cells(16, 1).Value = Markthree
.Cells(18, 1).Value = Markfour
.Cells(20, 1).Value = Markfive

End With

End Sub

I tried typing in "With Workbook("NEW_BOM")" above the "Wit
Worksheets("GIRDER")" But didn't work. The macro works fine in th
same workbook, but just don't know what to type in to make it go to th
other workbook named "BOM_NEW".

Any help is appreciated

--
dl
-----------------------------------------------------------------------
dlb's Profile: http://www.excelforum.com/member.php...fo&userid=1648
View this thread: http://www.excelforum.com/showthread.php?threadid=38280