Take CheckBox info, and put Y/N in corresponding box on next sheet

Hello all, I appreciate any help. I'm looking for help to setup this workbook. there are two checkboxes on sheet 1, which need to transfer either a yes or a no to sheet 2, then reset. The Y/N needs to go in the corresponding column on sheet 2, which would be todays date. wasnt sure how to manage that. Book1.xlsx

sorry, uploaded it before i saved it. here it is.Book2.xlsx

Hi robnez,

Try the attached file, to see if it does what you want.

I had problems with your Controls, probably because I'm using Excel 2003. Because I'm using
Excel 2003, you should not use my file, because some Excel features not available in Excel 2003
may be lost.

I deleted your controls on Sheet1, and replaced them using a Macro that should work in your version
of Excel.

Please note that cell 'F3' on 'Sheet2' is 'Y ' (Y space) and is not counted (from your original).


------------------------
To enable Macros and to Run Macros see the following:
http://office.microsoft.com/en-us/ex...010031071.aspx
http://office.microsoft.com/en-us/ex...010014113.aspx
If help is still needed do a google search for 'youtube excel enable macro' and/or 'youtube excel run macro'.

To access Visual Basic (VBA) see:
http://www.ablebits.com/office-addin...a-macro-excel/
a. Click on any cell in the Excel Spreadsheet (may not be needed).
b. ALT-F11 to get to VBA.
c. CTRL-R to get project explorer (if it isn't already showing).
d. Double Click on a 'Module Name' in 'Project Explorer' to see code for that module ('Sheet1').

Macro Installation Insructions:
a. Open this Workbook
b. Open the Workbook that needs to have the Macro Installed (Target Workbook).
c. In the Project Explorer, 'Right Click on ModYesNoCheckBoxes associated with this file.
d. Export ModYesNoCheckBoxes
e. 'Right Click' on any Module in Project Exlorer for the 'Target Workbook'
f. Import Module ModYesNoCheckBoxes into the 'Target Workbook'.
g. Save the 'Target Workbook'.

Please let me know if you need any changes or help with anything.

Lewis

I downloaded the file and followed your instructions. when I click submit though, it puts in a Y/N in the entire column on sheet 2.

each box on sheet 2 is a call in essence, and i just need the checkbox to show whether the answer is yes or no on a per call basis.

I thought you wanted 'Y' or 'N' on the entire column. How would I know which box on Sheet2 to put in the 'Y' or 'N', unless there is a check box for each row? A check box in each row is not difficult to do, if that is what you want.

I apologize, I guess I should have explained it a little better. I definitely appreciate your help! I do not need an individual check box for each line. Simply when a call comes in, after the call I need to select yes or no. the sheet would then go to the day selected in the dropdown list, and in the next empty cell enter whether Y or N was selected. then reset for the next call. I think i can try to figure it out with what you've given me.

Thanks for the kind words.

Now I understand what you wanted. If you have any problems or any more questions please ask.

Lewis