I believe that MS Query will clear any cells in rows in the query
range that aren't part of the query or formulas. You may have to make
some sort of lookup table to get the manual information on the correct
rows.

I usually keep seperate query sheets in my projects that only contain
the query and formulas that calculate additional fields, then copy
pertinent info to summary or report sheets.

If you resolve without using either of these methods, please post.

Cliff Edwards