Can't copy function from worksheet to another
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.
Copy-Formula-Problem.xlsx
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.
Copy-Formula-Problem.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I'm quite embarrassed and confused. Thanks for your help.