In my workbook, I have two tables (with different row numbers/column numbers) in a "database" sheet. Table1 has data input manually, which I want to paste via macro into Table2 in the same columns; ie. the data in Table1, Column "City" must be copied and pasted into Table2, Column "City". Table2 is empty and should not have to be cleared first (I think) because I will only need to run the macro once.

Can anyone point me in the right direction with this problem? I have been searching for some sample code and generally found the following: 
Worksheets(“Sheet1″).Range(“A1:D4″).Copy _
Destination:=Worksheets(“Sheet2″).Range(“E5″)
However how can I modify this for tables instead of ranges, as well as defined columns within those tables?

Thanks in advance