Row data coming from microsoft visual sudio express into Excel help needed

[IMRAY]

Hi

I have a form created in Microsoft Visual Studio Express

This is to input hours worked calls made etc

I can get it to save to a new excel sheet and overwrite it daily

I have also managed to get the single row of inforamtion into my target spreadsheet that will calculate pay and generate graphs etc

The problem is when it copies across I am using = [vbexcel.xlsx]sheet1!B1 same for different cells B2,B3 etc.

This comes in fine but the next day it will overwrite I am looking for this information to stay and to then move onto the next row by itself

Hope this is clear and someone can assist

thanks