Quote:
Originally Posted by FNMGR
It kept tying to get me to link to a worksheet when i did the formula then tried to find/replace within the formula. I found it just as easy to create the first set of formulas, set as text and copy all those into my columns then do the find/replace. it worked and only took 10 minutes to do 85 sheets so i wasnt complaining much
|
Very bizarre. I just tried it on your file and got nothing of the sort.
I've emailed it back to you so you can give it a try. Perhaps you were doing it a different way to me. Not that it matter as you've sorted it now anyway :)