LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I insert simple checkbox which can be checked by a click? mgreen74 Excel Discussion (Misc queries) 5 August 19th 09 04:31 PM
Change Single-Click Functionality? Wuddus Excel Discussion (Misc queries) 2 September 10th 07 11:54 AM
Concatenate: Multi-Line Cell with 2 single line cells BEEJAY Excel Worksheet Functions 0 February 15th 07 08:53 PM
Combination chart: primary data labels obscure line series on secondary axis Uhl Charts and Charting in Excel 3 December 12th 06 08:52 PM
Click event for checkbox from Forms toolbar Carolyn Excel Discussion (Misc queries) 6 September 11th 06 08:16 PM


All times are GMT +1. The time now is 04:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"