+ Reply to Thread
Results 1 to 2 of 2

Is it possible to write a fomula (cell is linked to other file) using the cell references

  1. #1
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    268

    Is it possible to write a fomula (cell is linked to other file) using the cell references

    Hello Friends,

    PFA 2 files.

    Is it possible to write a formula given in B16 of Summary.xls file using the cell references mentioned in B2:B12 ?

    Please assist.
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Is it possible to write a fomula (cell is linked to other file) using the cell referen

    You could do this using INDIRECT, but that only works if the source file is also open
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Linked sheets, cell references help
    By Jetstar77 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-08-2018, 05:30 AM
  2. Trying to Write a Formula within a Cell that References Another Object
    By derpin101 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-28-2014, 12:56 AM
  3. [SOLVED] Macro to write a formula with dynamic cell references
    By alpha608 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-27-2013, 12:18 PM
  4. Save file using cell references & mandatory cell input
    By Plantation in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-22-2013, 12:46 PM
  5. Replies: 0
    Last Post: 06-11-2007, 09:14 AM
  6. vlookup with linked cell references
    By JAB in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-20-2006, 01:00 PM
  7. Copying linked cell references.
    By Shams in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-03-2005, 10:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1