views:

31

answers:

0

I have several models that will need to be translated to other languages and I want to put all text strings on a separate tab so they are all together. I need a utility/tool to locate standalone and embedded text strings, move them to another tab, and replace the original text string with the cell reference to the new location. A bonus would also create a dynamic named range and use that in the original cells instead of absolute references. Does anyone know of a tool or utility that can do that? Thanks!