Macro for downloading once per day - avoiding data being overwritten?

[Zhevr]

Hi,
I'm creating an excel sheet which is downloading air quality data once per day and calculating the average from the last 24 hours.
I'm a newbie with macros and am currently setting it up as a download when the document is opened and a macro to clean out all the unnecessary input imported and calculating the average. I want that average to be transferred to a separate sheet with the date of the current day. Since the macro will run once a day it won't be a loop. I want the result to be a table with dates and averages from all the days the macro was run.

How do I make sure the data from the day before isn't overwritten when setting up the macro?

 

[offthelip]

Assuming you are writing the data to a new sheet ( I assumed sheet2) starting in column A, you can detect which is the last row with data in it using these lines of code:

With Worksheets("sheet2")
LastRow = .Cells(Rows.Count, "A").End(xlUp).Row
End with

Having found the last row you just write your new data into the next row, save and repeat the next day