[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Can't copy function from worksheet to another

Posted on 2014-01-08
2
Medium Priority
?
231 Views
Last Modified: 2014-01-08
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
0
Comment
Question by:thutchinson
2 Comments
 
LVL 54

Accepted Solution

by:
Rgonzo1971 earned 2000 total points
ID: 39765812
Hi

Done

Copy-Formula-ProblemV1.xlsx

What was the Problem?

Regards
0
 

Author Closing Comment

by:thutchinson
ID: 39766167
I don't know what was wrong.  I can copy it easily now.

I'm quite embarrassed and confused.  Thanks for your help.
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question