Originally Posted by Spencer101

You shouldn't have had to do all that stuff with text formats. As long as the formulas were set for the first sheet and references locked so the column/row can be dragged sideways/downward (depending on your setup) you could just use find and replace on each column/row in turn to change the sheet reference to the next and the next. It's a horrid workaround, but probably easier than the alternative if you only had to do it once.

The alternative would be writing the formulas using =INDIRECT() to reference each sheet name with a column/row header. It's easy enough to do if you know how to use it, but without example sheets I couldn't tell you how to set it up.

Hope it's of some help at least.

S.

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

Originally Posted by Spencer101

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 :)