I have a cell that calcs off another cell. When I re-sort, I loose the calc.
I tried absolute and relative cell references and that did not work. How do
I link the two together so that the formula changes when the data is
re-sorted? I tried paste link that didnt work either. Any suggestions are
greatly appreciated.