Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X
If I write a function as a program in one document is there a way to use it in another document without re writing it?
Aside from copy and paste?
You can reference one document in another "insert Reference." It effectively inserts the WHOLE DOCUMENT at the point of reference.
Hi Ed,
you have to use, in the new worksheet, the reference (to the old worksheet) instruction :
