+ Reply to Thread
Results 1 to 4 of 4

Use value/ formula from another sheet

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2010

    Question Use value/ formula from another sheet

    Hi, a friend of mine send me a loan calculation sheet. I want to be able to send data to that sheet, calculate it and automatically send the result back to my sheet that I'm working on. Is this possible?? In advance many thanks for any help.



  2. #2
    Forum Expert
    Join Date
    MS-Off Ver
    Office 365

    Re: Use value/ formula from another sheet

    That would be possible with a macro. Possibly even making an add in. You need to supply a sample workbook if you want someone to take a look at it.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  3. #3
    Valued Forum Contributor loginjmor's Avatar
    Join Date
    Cedar Rapids, Iowa
    MS-Off Ver
    Excel 2013

    Re: Use value/ formula from another sheet

    Hi -

    If the loan calculation sheet is an Excel spreadsheet you should be able to reference cells directly between the two spreadsheets.
    If this has solved your problem, please edit the thread title to add the word [SOLVED] at the beginning. You can do this by
    -Go to the top of the first post
    -Select Thread Tools
    -Select Mark thread as Solved

    If I have been particularly helpful, please "bump" my reputation by pressing the small star in the lower left corner of my post.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16

    Re: Use value/ formula from another sheet

    Hi and welcome to the forum

    What you want sounds fairly easy, however to be able to offer suggestions, we will need to see what you are working with. i would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that
    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    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


+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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