Cell range data moving from one sheet to another sheet in the same workbook

[bchdiva]

Im new to this forum. I work at a school and I am trying to create a school deposit slip that teachers can record when students pay for a field trip. At the end of the trip teachers must re-record the same information onto another sheet. In an effort to have teachers teach and not be bookkeepers I am trying to simplify the process:

200 student - Deposit slip daily - could be only 10 students who pay that day
Name Date Amount Check Cash

Field trip form the names are already entered 200 students. I want the information that is typed into the deposit slip to automatically find that student and fill in the information but only certain cell range - not the whole row.
or
type into the field trip form and link to deposit slip. The only thing with the deposit slip is that it is cleared out daily for an accurate daily accounting.

Hope this makes sense.

[arlu1201]

So if i understand it correctly, you want the following -

1. The user will enter the details into sheet1 and clicks on a button.
2. The button will copy the data to the Blank sheet.
3. The button clears the contents of sheet1.

Let me know if i have missed anything.

[bchdiva]

Let me see if I can explain this better. Our school system requires a daily deposit record and an end of activity accounting record. Currently teachers must record the collection from students on one sheet and transfer the same information onto the second database. The deposit record must be cleared out daily so that we have an accurate account of money collected on that day only. So the next day the deposit slips starts fresh but the activity accounting record needs to keep the information that was previously entered. So in the end I may have 10 deposit records and 1 activity accounting