Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
CHECK BOX HELP PLEASE.
My sheet contains 80 rows. (80 competitors). Their results are posted, one row to a competitor. Starting on row 7 - 87 I have a check box (default €“ unchecked) in cell K7. Its purpose is to indicate, whether the competitors times qualify for the event, There are three timers. The three times are averaged to give €śThe Time€ť. If they run over their time, this checkbox should be clicked and the previously entered times in C7,E7,E8 should be replaced with NIL. This check box will be in Col k on every row. I can record a macro to do this on that line, but I want to use a relative function so that I can copy it down the page to make give the same code to every row, instead of having 80 macros. I have nearly been there but everytime I get close, I seem to come up with something not quite right. Any help very much appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Check box hero needed please. | Excel Discussion (Misc queries) | |||
formula needed to sum check marks | Excel Worksheet Functions | |||
formula needed to sum check marks | Excel Worksheet Functions | |||
formula needed to sum check marks | Excel Worksheet Functions | |||
CHECK BOX HELP NEEDED PLEASE | Excel Programming |