Posted by Darren Smith on May 07, 2001 2:34 PM
If I have five cells A1-A5 with five numbers in them (golf scores) and I do a calculation on these five cells to figure out a golf handicap it works great, but I want to be able to add a number to A6 and have the calculation figure out the handicap on A2-A6 now, how can I do this without redoing the calculation. I have been trying to do this with macros and a button but I cant seem to get it to work. Any help??