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
thutchinsonAsked:
Who is Participating?
 
Rgonzo1971Connect With a Mentor Commented:
Hi

Done

Copy-Formula-ProblemV1.xlsx

What was the Problem?

Regards
0
 
thutchinsonAuthor Commented:
I don't know what was wrong.  I can copy it easily now.

I'm quite embarrassed and confused.  Thanks for your help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.