Thread: Macro help
View Single Post
Old 04-16-2010, 07:29 AM
NEHicks503 NEHicks503 is offline Windows XP Office 2007
Join Date: Apr 2010
Posts: 4
NEHicks503 is on a distinguished road
Default Macro help

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?
Reply With Quote