Excel Formula Sheet to be used in several workbooks
- or -
Post a project like this1429
£20(approx. $25)
- Posted:
- Proposals: 4
- Remote
- #2831370
- Completed
Description
Experience Level: Entry
I am looking for someone who can create a formula sheet that contains links to several worksheets within the workbook and can be used in other workbooks.
The sheet (Competency Profile: Sample-Competency Profile file attached) needs to be used in several workbooks that contain sheets with the same names/structure (ex. Sample Target Sheet File attached). The issue is if I copy and paste the formula sheet with links to the Sample Target Sheet it refers to sheets in the original workbook not in the Sample Target Sheet File workbook. I need a way to have a formula sheet that can be copied to other workbooks which links to sheets within that workbook with the same name (reference).
I have attached the Sample and the Target File for your reference. I will simply award this to the first to confirm that they can create such a formula sheet and describe what needs to be done in detail. This should be a very quick job for anyone who knows excel if it is in fact possible.
Thank you.
The sheet (Competency Profile: Sample-Competency Profile file attached) needs to be used in several workbooks that contain sheets with the same names/structure (ex. Sample Target Sheet File attached). The issue is if I copy and paste the formula sheet with links to the Sample Target Sheet it refers to sheets in the original workbook not in the Sample Target Sheet File workbook. I need a way to have a formula sheet that can be copied to other workbooks which links to sheets within that workbook with the same name (reference).
I have attached the Sample and the Target File for your reference. I will simply award this to the first to confirm that they can create such a formula sheet and describe what needs to be done in detail. This should be a very quick job for anyone who knows excel if it is in fact possible.
Thank you.
Faisal C.
100% (46)Projects Completed
42
Freelancers worked with
34
Projects awarded
32%
Last project
5 Feb 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies