Is this possible to do. Yes. Is it a good way to do something like this no.
Excel works best when only one person is trying to access it at a time. It
sounds like what you are trying to do is not that intricate. Microsoft Access
is probably a better tool for what you want to accomplish. If you are not
familiar with Access then You can try the Excel route but you will have
possible problems with performance (one Excel sheet having to open and close
another sheet repeatedly has inherant overhead issues) and or concurency
problems (many users trying to access the same data all at once.)

"brackeva" wrote:

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!