| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check Box from sheet to sheet
Here's what I am after and I can't figure this out:
4 worksheets. 1 main sheet and the other 3 drive off the main sheet. It's so I can fill everything in once, but send to different Venders with their names on it. Anyway, on Sheet one there is 3 checkboxes: Prelimanary Quote Final Quote for new part Final Quote for existing part I want to be able to check one and have that option copy over by itself to the other 3 sheets so I don't need to check mark the same thing over and over again. Thank you! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Check Box from sheet to sheet
Jerid,
You can accomplish this with some VBA code that runs when the change event for these check boxes occur. -- http://HelpExcel.com 1-888-INGENIO 1-888-464-3646 x0197758 "Jerid B" wrote: Here's what I am after and I can't figure this out: 4 worksheets. 1 main sheet and the other 3 drive off the main sheet. It's so I can fill everything in once, but send to different Venders with their names on it. Anyway, on Sheet one there is 3 checkboxes: Prelimanary Quote Final Quote for new part Final Quote for existing part I want to be able to check one and have that option copy over by itself to the other 3 sheets so I don't need to check mark the same thing over and over again. Thank you! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Check Box from sheet to sheet
I am not a VBA guy... wasn't sure if there was a way to tell Button B to be
checked accordingly to Button 8. Like an option somewhere in the properties. Thanks anyway. "galimi" wrote: Jerid, You can accomplish this with some VBA code that runs when the change event for these check boxes occur. -- http://HelpExcel.com 1-888-INGENIO 1-888-464-3646 x0197758 "Jerid B" wrote: Here's what I am after and I can't figure this out: 4 worksheets. 1 main sheet and the other 3 drive off the main sheet. It's so I can fill everything in once, but send to different Venders with their names on it. Anyway, on Sheet one there is 3 checkboxes: Prelimanary Quote Final Quote for new part Final Quote for existing part I want to be able to check one and have that option copy over by itself to the other 3 sheets so I don't need to check mark the same thing over and over again. Thank you! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Check Box from sheet to sheet
Jerid,
Email it to me @ & I will provide an example -- http://HelpExcel.com 1-888-INGENIO 1-888-464-3646 x0197758 "Jerid B" wrote: I am not a VBA guy... wasn't sure if there was a way to tell Button B to be checked accordingly to Button 8. Like an option somewhere in the properties. Thanks anyway. "galimi" wrote: Jerid, You can accomplish this with some VBA code that runs when the change event for these check boxes occur. -- http://HelpExcel.com 1-888-INGENIO 1-888-464-3646 x0197758 "Jerid B" wrote: Here's what I am after and I can't figure this out: 4 worksheets. 1 main sheet and the other 3 drive off the main sheet. It's so I can fill everything in once, but send to different Venders with their names on it. Anyway, on Sheet one there is 3 checkboxes: Prelimanary Quote Final Quote for new part Final Quote for existing part I want to be able to check one and have that option copy over by itself to the other 3 sheets so I don't need to check mark the same thing over and over again. Thank you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mutiple Check boxes flashing on sheet | Excel Discussion (Misc queries) | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
| linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
| Naming & renaming a sheet tab | Excel Worksheet Functions | |||
Hybrid Mode
