View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BradleyP BradleyP is offline
external usenet poster
 
Posts: 3
Default freezing formulas when cells move

I have an inventory spreadsheet where I compare the values in 2 columns to
make sure they equal 0. If the 2 values in each row to equal 0 when I
subtract one from the other (A23-B23), this lets me know that the inventory
price has not changed. However, because the new inventory list may have more
or less items that the current inventory list, I have to move cells up or
down to align the similar inventory parts.

I want to put a column to the side where I subtract current inventory value
from new inventory value and get a result of 0. But when I move one column up
or down, the formula changes accordingly. I want to be able to freeze the
formula column so that it always says "A23-B23" even when I move A23 up or
down.