Hi All,

I have a userform that accepts user inputs and emails it to me once users
click "Submit" on the userform. Before being emailed they are stored in a
workbook on a shared drive.

What is happening is: this workbook that is emailed to me stores the user
inputs of each user in a separate row, and hence I am receiving the whole
workbook with inputs of all the users.

What I want: I want to receive just the current users data. I dont want to
receive the entire workbook, but the data that has been inputted by the last
user only. (For e.g. only the last row updated in the workbook) and not whole
workbook.

Is there some code I can put in that will email me just the last user input
and not the previous inputs?

Please help
I hope I made it clear

Thanks in Advance