#8 - Your dependency view will look a little different. #4 - In the query you are using to put your JEs to the workbook, just Merge, not Merge as New, with the comment field. Note: if your original table is comeing from Power Query, and yours may be, then modify my steps as follows: make sure the first two tables are not loaded, but load the new merged table. You can see how this looks in Power Query's Dependency View in the View Tab.Once done, Expand the Comments table, and uncheck everything except the Comment field itself.(You don't worry about this if you have one unique column, but here we need two columns for uniqueness) You do this by selecting first Account Number, then Journal Entry. Make sure the fields line up as shown here.Click the first query in Power Query and on the Home ribbon, Merge as new.Select your Comment table and load it to Power Query.Add a Comment field to your Comment table and make your comments.It also must have the column(s) that will be a unique link to the specific row you want I've used a combination of the Account Number and Journal Entry based on your screenshots. Create a new table in Excel that has your comments.See this file for what I've done, explained below. You need to use Power Query to keep them in sync. If you are using a fomula that does the same thing to all rows ( * 1.05%) for example, that will work, but you are trying to keep individual comments tied to specific rows. You cannot keep an Excel column in sync with a Power Query column.