mike21mcd
Board Regular
- Joined
- Sep 6, 2006
- Messages
- 67
I am creating three forms as drop down boxes. My fourth form is just a button.
Form 1 = Week #
Form 2 = Time
Form 3 = Description
I would like to populate these three forms, then when I select the fourth form (button), have the values within the first three forms be stored on another sheet. Adding to the complexity, my sheet names within the document will equate to Form 1, and I need to select the appropriate sheet to store the data according to the value in Form 1.
I hope this makes sense and appreciate any help you can offer....I am completely stuck on this one. Thanks in advance!
Form 1 = Week #
Form 2 = Time
Form 3 = Description
I would like to populate these three forms, then when I select the fourth form (button), have the values within the first three forms be stored on another sheet. Adding to the complexity, my sheet names within the document will equate to Form 1, and I need to select the appropriate sheet to store the data according to the value in Form 1.
I hope this makes sense and appreciate any help you can offer....I am completely stuck on this one. Thanks in advance!