Hi All, I am using Excel to track an event attendee list that is consistently being updated/added to by our marketing department. I want to add custom notes fields to the document so we can add commentary to each record in the sheet, but I don't want that information to get blown out each time the attendee list is refreshed. Is there a way to use Power Query to add editable fields to the original source document our marketing team is dropping?
@MStewart1102 No need for Power Query. There is an option to add a Note to a cell, which lets you add annotations about that particular row of data. There is also an option to add Threaded Comments, which let you @mention other people, and have a continuous conversation. Both stay with the cell you put them in, so no worries about sorting or filtering.