I need a simple input button that will take data entered by the user and
enter it into another sheet in the corresponding fields based on the
date. For example sheet Input! would have the user input fields
D10:D25 with data labels in C10:C25 and a drop down menu for the date
(D4). The user would select the date, enter the data and press the
input button.

The data would then be entered into a separate worksheet that has the
date in the range B5:AF5 with the fields below each date. I would like
to set it up so that the input button searches for each field in the
range A6:A65.

I know how to insert the button, and open VBA in order to attach the
code to the button, but I need help with the code.

Thanks.

-ep


--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=564563

Edward
It's not clear how the different ranges relate. If you wish, send me
your file or a sample of it. Include as much explanation as you can.
Examples of how/where you want the input data transferred would be most
useful. My email address is . Remove the "nop" from
this address. HTH Otto
"edwardpestian"
wrote in message
news:edwardpestian.2bhh3k_1153801211.981@excelforu m-nospam.com...

I need a simple input button that will take data entered by the user and
enter it into another sheet in the corresponding fields based on the
date. For example sheet Input! would have the user input fields
D10:D25 with data labels in C10:C25 and a drop down menu for the date
(D4). The user would select the date, enter the data and press the
input button.

The data would then be entered into a separate worksheet that has the
date in the range B5:AF5 with the fields below each date. I would like
to set it up so that the input button searches for each field in the
range A6:A65.

I know how to insert the button, and open VBA in order to attach the
code to the button, but I need help with the code.

Thanks.

-ep


--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile:
http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=564563