In an imported P&L I want to insert a column to calculate percent of sales.
How do I get each cell in the new column to divide it's appropriate numerator
(the cell immediately to the left) by a common denominator (the cell
containing the sales value)? When I copy a formula, it moves both the
numerator and the denominator down the referent column.

Thanks for any help. I know this is a simple fix, I just can't find it.