I have a spreadsheet with columns A-F pulling in data through MS query and
columns G-U having data the is manually entered by a user and is intended to
be "linked" to the data appearing in A-F.

To be more detailed, columns A-F represent customer order information from
our inventory system, while G-U represent payment information. When new
records are added or deleted within the query range on the left, rows ought
to be removed or added (with blanks) in the corresponding spots on the right.

I have tried changing the query properties to:
- insert entire rows for new data, clear unused cells
OR
- overwrite existing cells with new data, clear unused cells
This does not change the data on the righthand side.

Then, I added a bogus column G that contains a useless formula in the hopes
that the "fill down formulas in columns adjacent to data" option would force
data to the right to propogate down with the corresponding data on the left
when the query is refreshed. This doesn't work. Only the formula itself
propogates down.

How can I ensure that the data (entered manually) on the righthand side of
my spreadsheet continues to correspond to the data (from a query) on the
lefthand side when rows are added and/or deleted through the query refresh
process?