I am unable to copy a function from one Excel spreadsheet to another. My staff needs to use this formula on different incoming files on a regular basis.
For example: Attached is a file containing a tab called "Function Sheet". The function in COL B needs to be copied to COL K of the tab called "Orders".
The goal of the function is to extract a ProductID from the field Description.
Thanks for your help.