?
Solved

Excel formula to reference Active worksheet.

Posted on 2011-09-25
3
Medium Priority
?
270 Views
Last Modified: 2012-05-12
Hi experts,

I am attempting to copy a formula from one work book to another. Both are based on the same template, i.e cell layout, worksheet tabs etc.

I noticed that in the formula I am attempting to copy from there is a reference to the workbook i.e ([workbook1.xlxs). When attempting to copy to the new workbook it still references the original workbook I have copied from. I may be way off the beaten track on this one but is there anyway I can copy the formula and make it reference the active workbook?
0
Comment
Question by:Mattywerts
3 Comments
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 2000 total points
ID: 36596529
Hello

in the source workbook, select the formula in the formula bar and copy. Then paste it into the formula bar for the cell in the target workbook.

If you copy and paste the whole cell, this will create a link to the source workbook.

cheers, teylyn
0
 
LVL 42

Expert Comment

by:dlmille
ID: 36596537
Are you coding this in VBA?  Please provide your code to do what you're doing.  There are so many options, I could write a few paragraphs, lol!

Dave

0
 
LVL 1

Author Closing Comment

by:Mattywerts
ID: 36596600
Thank you for your help.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
In this article, I will demonstrate that how to do a PST migration from Exchange Server to Office 365. This method allows importing one single PST, or multiple PST's at once.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

569 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