+ Reply to Thread
Results 1 to 4 of 4

Dynamic funcationality in workbook

  1. #1
    Registered User
    Join Date
    02-28-2014
    Location
    Dubai
    MS-Off Ver
    Excel 2013
    Posts
    19

    Post Dynamic funcationality in workbook

    Hi,

    I have sheet1 along with three columns as below
    Result column will show the result after sum ** column A & B

    Please Login or Register  to view this content.
    This is simple that i will add this formula =A2+B2 in Result column cell C2.
    But i want to perform this addition action on Sheet2 and return the result in column C2 ** Sheet1.
    what formula should be populate in Result column ** Sheet1 that could catch addition formula from Sheet2 dynamically and display the result ** column A & B in Sheet1 .
    And what type ** formula should be use in Sheet2 to add two columns dynamically.

    The same concept that we are using in any functions like as below:
    Sub Function Plus (value1 As Double, value2 As Double)
    Plus = (value1 + value)
    End Sub

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Dynamic funcationality in workbook

    You appear to be asking how you can sum values from one sheet in a formula on another. In which case just iinclude the sheet name in the formula. e.g.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    02-28-2014
    Location
    Dubai
    MS-Off Ver
    Excel 2013
    Posts
    19

    Re: Dynamic funcationality in workbook

    Quote Originally Posted by Richard Buttrey View Post
    You appear to be asking how you can sum values from one sheet in a formula on another. In which case just iinclude the sheet name in the formula. e.g.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    - This is Sheet1
    Sheet1.PNG

    - You can see Code sheet which is currently empty

    My question here is:
    I want to write an addition function in Code sheet that will take values from Sheet1 A2, B2 and return the result value in the same Sheet1 in Result column
    Last edited by crimzon; 03-08-2014 at 11:03 AM.

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Dynamic funcationality in workbook

    Please don't upload pictures, they are generally useless - see guidelines in rule area. Actual workbooks are much preferred.

    Have you tried the obvious

    HTML Code: 

+ 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. Creating Dynamic Folders/WorkBook from a Sheet with Dynamic Path.
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 03-28-2011, 05:42 AM
  2. Dynamic Workbook Name
    By COHokie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-14-2008, 11:46 AM
  3. Dynamic reference to workbook
    By Misssy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  4. [SOLVED] Dynamic reference to workbook
    By Misssy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  5. Dynamic Range with another workbook
    By Carim in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-02-2005, 11: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