Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Amateur - Need Help!
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index/Match Amateur Question | Excel Worksheet Functions | |||
AMATEUR REPORTERS WANTED! | Excel Discussion (Misc queries) |