Select a Row from a Table and use that data elsewhere

[gheyman]

I have a very large table (Power Query table).

I want the user to be able to select an item and then have that item (the data in the cell) be loaded in a cell on another tab.
I hoped I could add a checkbox to a column or maybe a Yes/No column to the Table, but I didn't find anything on the internet that indicated that was possible (remember this is a table that gets refreshed).

My end goal is for the user to select information from a row somehow and then have that data load cells on another tab (I am doing this so the data remains consistant). They are selecting Vendor names and address, phone number..... You know how people are, if I let them just type it on the other tab, I will have 50 versions of the same thing.

 

[gheyman]

Got it.

Just added a column after the last column of the table and put a Data Validation list in (Yes, No). Then I am using Code to copy down the contents to the row, so when the table is refreshed it matches up (Same number of rows).