Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
checkboxes and cell-link references...is there a better way
Is there a quick way to copy a checkbox and have the cell-link reference not
remain constant? For example, I have a checkbox in cell A1 with the cell-link as B1. If I copy the checkbox to A2, would like the cell-link to be B2 (not B1.) Also open to alternative suggestions -- I have a worksheet with a check box next our client's names (500+ client names.) The list is grouped by company, sorted alphabetically by client. The worksheet needs to updated and resorted frequently and it is very cumbersome to redfine the cell-links. I have considered using Access but the users or the check sheet are not particullary "user-friendly" and we are all on different versions of the program. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
checkboxes and cell-link references...is there a better way
I'm trying to do the same thing, Kim. I also posted a question similar to
this without any helpful response. It seems that we've finally stumped the Excel Experts. Did you ever find an easier way? "Kim.in.Denver" wrote: Is there a quick way to copy a checkbox and have the cell-link reference not remain constant? For example, I have a checkbox in cell A1 with the cell-link as B1. If I copy the checkbox to A2, would like the cell-link to be B2 (not B1.) Also open to alternative suggestions -- I have a worksheet with a check box next our client's names (500+ client names.) The list is grouped by company, sorted alphabetically by client. The worksheet needs to updated and resorted frequently and it is very cumbersome to redfine the cell-links. I have considered using Access but the users or the check sheet are not particullary "user-friendly" and we are all on different versions of the program. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
checkboxes and cell-link references...is there a better way
radio silence, not a word! Very frustrating. This could be an extremely
useful function if it weren't so time consuming to set up....and it is even worse when you need to edit the worksheet. "mailrail" wrote: I'm trying to do the same thing, Kim. I also posted a question similar to this without any helpful response. It seems that we've finally stumped the Excel Experts. Did you ever find an easier way? "Kim.in.Denver" wrote: Is there a quick way to copy a checkbox and have the cell-link reference not remain constant? For example, I have a checkbox in cell A1 with the cell-link as B1. If I copy the checkbox to A2, would like the cell-link to be B2 (not B1.) Also open to alternative suggestions -- I have a worksheet with a check box next our client's names (500+ client names.) The list is grouped by company, sorted alphabetically by client. The worksheet needs to updated and resorted frequently and it is very cumbersome to redfine the cell-links. I have considered using Access but the users or the check sheet are not particullary "user-friendly" and we are all on different versions of the program. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I toggle the value of a cell by clicking directly on the cell? | Excel Discussion (Misc queries) | |||
how do i add "yes/no" checkboxes to a table cell or column? | Excel Discussion (Misc queries) | |||
How do I total range of cells that have checks in checkboxes? | Excel Discussion (Misc queries) | |||
ability to put checkboxes into a cell (not just onto) | Excel Discussion (Misc queries) | |||
Creating a check mark box | Setting up and Configuration of Excel |