Power Query Referencing

Riny_van_Eekelen 

Thanks for the quick response. I can't seem to find where to add a file, but essentially what I want to do is create a table from the power query table, that cross references it so that only new rows are added. Hopefully this would prevent links between check-boxes and functions from breaking when the referenced data increases. Not sure if the attached image helps;

Snapshot of table linked directly to Power Query.

Customer Name, Email, and Phone Numbers get pulled in from a file directory using PQ directly. The Inlocates and Scheduling columns are check-boxes that change the text of Column3 (currently populated with "999"), which combines the information from the check-boxes and the customer information into an email body to be sent to the customer.

We just need the checkboxes/textfield/cell data (whatever it needs to be) that indicate the status of the job to carry with that job as new items are added to the file directory power query points to, and the rows are "shifted down"

Would it be best to accomplish this using a secondary table that looks for new values in the PQ table and then pulls them in, similar to inserting? or would a self-referencing PQ table that holds on to the statuses of the checkboxes be best? (I believe this is the method mentioned above? still not sure on how it works, but I can research more if I can get confirmation it would be the best approach).

Thanks again for your help with this.

Brad