I am creating a Userform for an inventory management system, and I can't seem to figure out how to copy my data exactly where I want it in my workbook.

I am using Sheet2.jpg to collect raw material data, which I would like organized by date in my workbook Sheet1.jpg.

Say the date is today, 03/06/2012: I would like the "Quantity" to be copied to cell L11 in the worksheet titled "Title" to correspond with the date.

Basically, I'd like VBA to do something to the effect of: If Date = "xx/xx/xxxx" Then Copy Data from TextBoxQuantity to Cell "XX" in workbook "Title".

I'm sorry if I am not wording things properly, VBA is not my area of expertise. Actually, programming of any kind whatsoever is not my expertise. I seriously appreciate any assistance in this matter.