I have a spreadsheet that i need to add data from another spreadsheet daily.
Is there a way using vb that i can copy data from one spreadsheet to another,
but have the data go to the last row..

ie if i copy data to the first 20 rows, then the next day i need to copy new
data starting at row 21, and so forth each day.

I would really like to do this using vba. Thanks