Hi there lbargers,

You could try something like this ...

Sub CopyMyDataFromBookToBook()

Dim wbCopy as Workbook, wbPaste as Workbook
Dim wsCopy as Worksheet, wsPaste as Worksheet
Dim rngCopy as Range, rngPaste as Range

Set wbCopy = Workbooks("testLog.xls")
Set wbPaste = Workbooks("Script.xls")
Set wsCopy = wbCopy.Sheets("summary")
Set wsPaste = wbPaste.Sheets("findings")
Set rngCopy = wsCopy.Range("A1:A10")
Set rngPaste = wsPaste.Range("A1:A10")

rngCopy.Copy Destination:=rngPaste
Application.CutCopyMode = False

End Sub

Change the ranges to suit.

HTH

--
Regards,
Zack Barresse, aka firefytr
To email, remove NOSPAM


"lbargers" wrote in
message ...

Hi all,

How can I setup a macro that will pull data in from a range.. From one
xls spreadsheet(testLog.xls)(summary tab) to another
(Script.xls)(findings tab)?


--
lbargers
------------------------------------------------------------------------
lbargers's Profile:
http://www.excelforum.com/member.php...o&userid=32798
View this thread: http://www.excelforum.com/showthread...hreadid=527216