Help with Userform data placement into two sheets

[lilsnoop]

I am looking for assistance in having two fields in an existing userform of mine place data into two separate worksheets but in the same workbook. Currently the data in my userform places data in various columns on a sheet labeled "2010". I would like my userform field data for "assigned" and "status" to remain in the same place for the 2010 sheet, but to be also placed in another sheet labeled "Assignment"
In the "Assignment" sheet the "assigned" data would begin in column C, and the "Status" data would be in column D. It would be preferred to have the data placed in these columns, but in the corresponding row number from the 2010 sheet. I hope this makes sense and is possible. Here is my existing code which is affiliated to my current user form, which places the data in the 2010 sheet only. Thanks in advance for any assistance and/or time looking at this!
I've attached a sample workbook to hopefully help with understanding what I'm trying to do. Thanks again!

Please Login or Register  to view this content.

[john55]

hi
try to add this piece of code to yr existing code and see if it helps you.

Please Login or Register  to view this content.

[royUK]

You don't need all thos with statements

Please Login or Register  to view this content.

[lilsnoop]

Sorry for my belated reply, but it was a hectic & long day at work today. I really appreciate both of your time looking into this for me. I've tried each of your code and neither has worked for me without errors developing. I'm sure it is something I'm doing when trying to import it in/replace my existing code. Any possibility you could put the code in my sample and re-attach it? That would help me figure out what I'm doing wrong. Thanks so much if this is possible!

[john55]

Roy, thank you!

lilsnoop, see the file attached, hope it helps you!

[lilsnoop]

Thanks again to the both of you! Got my file working just like I needed it to due to the assistance of both of you!

[john55]

glad to be of help!