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!![]()
Bookmarks