I have a form that is filled out daily. I have linked the data to a second worksheet to save the daily data. I need to make the second worksheet start a new row each day so that each day's data is saved. How would I write a macro for this?



Sheet 1 - column B - B3, B6, B10, B13, etc - transfers to Sheet 2 - Row A1, B1, C1, D1, etc. thru column K - when column K is filled in, then the macro should tell it to move to row 2 which will then start the next day.

Is this possible?