I would like to make a sheet with a set of Checkboxes that once pressed will populate cells with information.
In the included file you see what I am trying to do. The checkboxes are in row 2 and the information resides in rows 4 thru 8. If the user selects checkbox A2 then “25 Love Lane” is populated into cell A4. If the user selects checkbox D2 then “90 Ferry Ave” will be populated in cell A7.
How can I accomplish this? Thanks