Transferring Data

[Ralobean]

I am trying to write a script that will copy only rows of cells that contain data in a table, and copy them to another excel sheet in a different table. THE TRICK IS :banghead: every time I run the macro, I dont want the "new data" to overwrite the "old data"(or the last time I ran the macro). I simply want it too print the new data on the next empty row below(with no data) in the table where the data is transferred every time I run the macro.:bug: HELP!!! :crying:

[mancubus]

welcome to the forum.

post your workbook pls.
make sure your workbook contains the source table and destination table.
clearly define your requirement.