Table 1 has data, and Table 2 has formulas referencing data from Table 1. If
I sort the data in Table 1, the formulas in Table 2 end up referencing the
wrong cells. Is there a simple way to fix?

Thanks,

Mike