Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to create primary/secon single click checkbox line autopopulat
I want to create a checkbox type spreadsheet that will autofill line data to
a total sheet. What do I use? Formulas? Which one, and how? ExCell H63 will be filled in with the amount in F55 if I check G55. Then check a secondary, (G45), and H64 will will autofill with F45 F G 45 103 (X) checked second 55 87 (X) checked first 72 19 (X) checked last AKA...Applicant 87 (H63) first to populate Spouse 103 (H64) Second Child 19 (H65) next and so on |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
R: How to create primary/secon single click checkbox line autopopu
Perhaps a simpler alternative to consider, which gives you an equivalent
functionality Instead of checkboxes, just input the numbers: 1,2,3 into G55:G57, depending on which is to be entered 1st, 2nd or 3rd Then in H63: =IF(ISNA(MATCH(ROWS($1:1),$G$55:$G$57,0)),"",INDEX ($F$55:$F$57,MATCH(ROWS($1:1),$G$55:$G$57,0))) Copy down to H65. H63:H65 will return the results that you seek. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "ktyner" wrote: I want to create a checkbox type spreadsheet that will autofill line data to a total sheet. What do I use? Formulas? Which one, and how? ExCell H63 will be filled in with the amount in F55 if I check G55. Then check a secondary, (G45), and H64 will will autofill with F45 F G 45 103 (X) checked second 55 87 (X) checked first 72 19 (X) checked last AKA...Applicant 87 (H63) first to populate Spouse 103 (H64) Second Child 19 (H65) next and so on |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I insert simple checkbox which can be checked by a click? | Excel Discussion (Misc queries) | |||
Change Single-Click Functionality? | Excel Discussion (Misc queries) | |||
Concatenate: Multi-Line Cell with 2 single line cells | Excel Worksheet Functions | |||
Combination chart: primary data labels obscure line series on secondary axis | Charts and Charting in Excel | |||
Click event for checkbox from Forms toolbar | Excel Discussion (Misc queries) |