jump to the next row with macro

Hi everyone.I have a data that updates once a day. I want Excel to take a copy of each new bit of data as it comes in, and copy and paste it into a column on the same sheet so that it can be stored. I then want it to move down a row and take the next reading and so on, so that each time a new reading comes in, Excel takes the value and puts it in the next row down in a set column.Any suggestions out there??
Thanks a lot.
here is the code:

Please Login or Register  to view this content.

thanks!!! it's working