+ Reply to Thread
Results 1 to 4 of 4

Use input for an external formula

  1. #1
    Registered User
    Join Date
    09-15-2015
    Location
    Italy
    MS-Off Ver
    2019
    Posts
    49

    Use input for an external formula

    Hi, I calibrated a formula in a spreadsheet and now I'd need to use in another, in which I have the inputs.
    Is it possible to call a formula from a spreadsheet to another?

  2. #2
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Use input for an external formula

    the reference syntax to link to cells in sheets outside of the active one is:

    =Sheet_name!Cell_address

    https://support.microsoft.com/en-us/...e-c835903cebaa

  3. #3
    Registered User
    Join Date
    09-15-2015
    Location
    Italy
    MS-Off Ver
    2019
    Posts
    49

    Re: Use input for an external formula

    Hi, It's not my case: in spreadsheet A I have inputs, in spreadsheet B the formula and a set of data I need to calibrate it.
    I wish to take the input arguments in A, let formula in B calculate the result and write it in A
    Attachment 705377

    This in order to avoid to type the data for many times from one sheet to another

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,704

    Re: Use input for an external formula

    Your attachment is invalid. Please follow the instructions given in the yellow banner at the top of the screen.

    Hope this helps.

    Pete

+ 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. Replies: 0
    Last Post: 03-02-2020, 05:53 AM
  2. Printing external PDF files based on user input
    By aglawrence in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-26-2017, 07:06 PM
  3. vlookup to external file with dynamic input
    By foruforewer in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-12-2013, 02:21 AM
  4. [SOLVED] external link reference formula inside formula user input
    By jscc in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-20-2012, 04:29 PM
  5. Worksheet_change issue. Change is from external source not user input.
    By beat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-21-2012, 01:54 PM
  6. Unable to input external links
    By ianm in forum Excel General
    Replies: 2
    Last Post: 12-18-2009, 10:26 AM
  7. input for external reference
    By kspurgin in forum Excel General
    Replies: 1
    Last Post: 08-15-2006, 12:45 PM

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