What you want to do is fairly easy but you need to be more specific on what you mean by "Cell may vary at any time - coding should be dynamic"
Do you want all cells in column D to be calculated when columns B and C are not empty?
Do you want to click on a cell and have the result of cell(column of the cell - 1) - cell(column of the cell - 2) ?