Hi everyone,

I need to create an excel form which I will either email weekly or place on
our shared drive for weekly access, in which my co-workers can enter their
weekly sales numbers. The form should contain a button, which would
automatically send those numbers to my already created spreadsheet. Each
co-worker has their own worksheet within the workbook, so if for example, Bob
chooses his name from the dropdown list, his numbers will automatically be
sent to his specific worksheet. Is using VBA the only way to do this? I'm new
at this and having a lot of trouble with writing the code. I have the
userform created, I'm just having a lot of trouble getting beyond the basics.
Would data validation be useful for this? I haven't worked with that before
either.

Also, is there a way for a form in one workbook to send the information to a
spreadsheet set up in another workbook?

Thanks!