I have a form, that is to be used repeatedly. The info is parsed to a temp sheet in the same workbook where it is organized correctly and then copied to a different workbook, a batch file. I have two problems. 1, it's duplicating the first three rows of data from my source file when pasting to my destination file. 2, It's overwriting every previous row of data in my destination file instead of finding the first empty row and concatenating the data.

Heres my code.

Sub test3()
Dim x As Long, y As Long
Workbooks.Open Filename:="M:\aaclosing\2008\test\Funding Entries.xls"
x = Workbooks("Recon Builder.xls").Sheets("JEs").Range("a65536").End(xlUp).Row
y = Workbooks("Funding Entries.xls").Sheets("Funding Entries").Range("a65536").End(xlUp).Row
Workbooks("Recon Builder.xls").Sheets("JEs").Range("A2:G" & x).copy
Workbooks("Funding Entries.xls").Worksheets("Funding Entries").Range("A1:G" & y + 1).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
end sub