I'm having trouble writing a macro that when the submit button is clicked, it will record certain information to a hidden sheet. Basically its a simple expense statement form, and when they click Submit, I want it to record the invoice number(M2), their name (C4), the date (M3), and the total amount (L26) to a master log that is hidden within the spreadsheet. I know how to make a macro write from one spreadsheet to another, my issue is having it take this information and go to the next line. I don't ever want it to overwrite what was previously submitted. So for example, if the employee has 25 expense statements, we should be able to look at the hidden log and see each one.

Thats the basis of what I was looking for. My next question would be, is it possible to have this write to a master file on a network drive? This way all expense statements from all employees are recorded to a master file?

Thanks for your help.