Use vba to copy cells from one workbook to another?

[jondavis1987]

I have a workbook where I enter information.
The workbook I enter information is is 3011-EST-1604
This workbook has two sheets in it. The sheet I need information off of is sheet2
Sheet2 Cells J18:25

The workbook I have to transfer data to is called Yearly HMA Charts
The worksheet is called "Sieves"
I need it to go into a table that I already have set up. It would need to enter at the bottom of the table and in column G.
So right now if I were to copy and paste those cells it would expand the table and go into G1640:G1647

I don't really know where to even start with this and would I have to have both workbooks open or is it possible to do it without having open the one that gets pasted into

 

[jondavis1987]

Sub Open_ExistingWorkbook()
Workbooks.Open (" Users\jdavis\Dropbox\Quality Control\Asphalt\Misc\Yearly HMA Charts.xls ")
Workbook(”Users\jdavis\Dropbox\Quality Control\Asphalt\Asphalt Worksheets\3011-EST-1604.xls”)
Sheets(“Sheet2”).Range(“J18:J25”).Select
Selection.Copy
Workbooks("Users\jdavis\Dropbox\Quality Control\Asphalt\Misc\Yearly HMA Charts.xls ").Select
Sheets(“Sieves”).Select
 
Workbooks("Users\jdavis\Dropbox\Quality Control\Asphalt\Misc\Yearly HMA Charts.xls ").Close SaveChanges:=True
End Sub

I think this will work close for what I have but I don't know how to make it paste into the table