Hello All,
I have two excel files: form1.xls and data1.xls.

In form1.xls is a simple form. In the first column is a date, the next ten columns are labeled for people (Brian, Jay, Michelle...). In the form, the date (properly coded as a date) is put in the date column and then under each person's name is a number (number of tutoring sessions that day).

In data1.xls, the first column has 365 consecutive dates and then the next ten columns are labeled for the same people.

What I would like is to be able to run a macro from the form (by the press of a button) that will copy the data in the form and paste it into the appropriately dated row. That way I can keep all of the cumulative data. It is actually a bit more complicated than that, which is why I don't just have people fill in data1.xls, and I also want the data in data1.xls to be inaccessible.

The data doesn't neccessarily have to be copied and pasted if there is an easier or more logical way to do it. Also, I know how to copy and paste a macro and assign a macro to a button. Thanks so much! The people on this forum have been very helpful and I sincerely appreciate it!
Alan