Quote:
Originally Posted by FNMGR
I dont really have a solution. I had to manually do the first then i copied the formula as text into the other columns then did a find/replace to relace the "Sheet" name. Then a text to columns to get the text to convert back to general.
|
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.