you're not clear here - is the userform data stored separately ? its should
be raltively painless to save the data into another - say timestamped -
workbook in a particular folder, prior to any processing as soon as submit
was clicked. that would make life a lot easier





"sam" wrote in message
...
Hi All,

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

What is happening is: this workbook that is emailed to me stores all the
data that users input through userform, and hence is emailing me the whole
workbook with all data.

what I want: I want to reveive just the current users data. I dont want to
receive the entire workbook, but the current data that has been inputed by
the last user only.

I hope I made it clear

Thanks in Advance