Excel - Formula Loses Reference After Sort 1

[rjm65]

Area G10:AP122 has it's cells filled with a simple formulas like =K8*6. The formula in the cells always references row 8 (Quanity Required) in their respective column. The *6 can vary from cell to cell, it is not a fixed value. The problem is I should've written the formula(s) as =$K$6*6, because now when I sort by column F, the cells lose their reference. Is there a quick and easy fix to this or do I have to manually go in and add the $ to my formula in each cell.

Thank you,
Raymond

 

[SkipVought]

Hi,

Use Edit/Replace
[tt]
=K8*6
--------
=$K$8*6
[/tt]


Skip,

_{[red]Be Advised![/red] For those this winter, caught in Arctic-like calamity, be consoled...
Many are cold, but few are frozen!}

 

[rjm65]

Could it be any more obvious!!! DUH!!

It's been a long day, and sometimes the trees block the view of the forest. Thanks for the quick reply, I can get back to work now and chuckle at myself the rest of the day.

Raymond