Here is my forumla =SUM((A8*1000)/(1.732*B6)) hovever when I copy it down to the next cell i want the A8 to change to A9, A10, A11, etc.. but I want the B6 to remain fixed and not update to B7, B8, B9 every time I copy down a row.. any advice..
Thanks