+ Reply to Thread
Results 1 to 3 of 3

Need checkbox to display information from a row of data

  1. #1
    Registered User
    Join Date
    08-14-2013
    Location
    South Dakota
    MS-Off Ver
    Excel 2010
    Posts
    6

    Need checkbox to display information from a row of data

    I have very large excel file containing 6-7 columns of data per row, and between 3000-4000 rows. my columns include last name and first name, and then more columns of information pertaining to the person's name. I have a search set up so that I can search for either first name or last name and receive multiple rows of info depending on the search. However, I would like to create a code where when I click a checkbox next to one of the search results, the information contained in the entire row will appear in a separate area.

    I have attached the spreadsheet I have been working on. The data is on the second sheet, and the search box and results on are the first sheet.

    Please let me know how I can get all the information contained within a specific row to appear in the fields below the search box.

    Also, any comments/tips will be greatly appreciated!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    06-22-2013
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    65

    Re: Need checkbox to display information from a row of data

    rach3lmclark,

    Please see attached. You have linked each checkbox to the corresponding row in column G. We can then use the following formula to find which row is ticked.

    SUMPRODUCT(IF($G$5:$G$55=TRUE,ROW($G$5:$G$55),0))

    We can use the following formula MATCH(B9,$I$4:$N$4,0) against each field name in range B9:B15 to find which column the field we need to find. Put this in an index function and the correct data will be display - this is an array formula so <ctrl+shift+enter> and the curly brackets will pop in.

    INDEX($I$1:$N$55,SUMPRODUCT(IF($G$5:$G$55=TRUE,ROW($G$5:$G$55),0)),MATCH(B9,$I$4:$N$4,0))

    I have wrapped this inside a countif to an error message is displayed if more than one row is ticked. The full expression is

    =IF(COUNTIF($G$5:$G$55,TRUE)>1,"ERROR",INDEX($I$1:$N$55,SUMPRODUCT(IF($G$5:$G$55=TRUE,ROW($G$5:$G$55),0)),MATCH(B9,$I$4:$N$4,0)))

    Hope that helps.

    Regards

    David
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    08-14-2013
    Location
    South Dakota
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Need checkbox to display information from a row of data

    Thank you so much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Userform / Checkbox information Help Excel 2007
    By Excelnoub in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-07-2013, 12:24 PM
  2. Transferring information to a second (or third) spreadsheet if checkbox is checked
    By Outbound2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-08-2012, 10:38 PM
  3. How to display information in other columns with missing information
    By Derry in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-03-2011, 11:10 PM
  4. Overide the cell information through a checkbox
    By gsweta in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-01-2009, 05:55 PM
  5. checkbox information
    By leevi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-01-2007, 01:37 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1