I haven't touched VBA in a little while (years), and I was never very adept 
Here's what I was looking to do:
In my "Input" sheet, I have cells to be filled in by an end-user. The sheet is locked, save for cells C6:F6, C7:F7...C12:F12, all of which contain numeric data. When the macro runs, it should copy the contents to a new row in the "Data" sheet, and then zero the cells.
In the "Data" sheet, I want to add the date in column A, and essentially flatten the input table to get it on a single row. The idea is that the "Data" sheet builds with every use, and the "Input" sheet stays nice and trim.
Any help would be much appreciated!
Here's what I was looking to do:In my "Input" sheet, I have cells to be filled in by an end-user. The sheet is locked, save for cells C6:F6, C7:F7...C12:F12, all of which contain numeric data. When the macro runs, it should copy the contents to a new row in the "Data" sheet, and then zero the cells.
In the "Data" sheet, I want to add the date in column A, and essentially flatten the input table to get it on a single row. The idea is that the "Data" sheet builds with every use, and the "Input" sheet stays nice and trim.
Any help would be much appreciated!
