+ Reply to Thread
Results 1 to 4 of 4

Function to Input sets of data, then write the output

  1. #1
    Registered User
    Join Date
    07-13-2013
    Location
    New York
    MS-Off Ver
    Excel 2003
    Posts
    2

    Function to Input sets of data, then write the output

    I was hoping I would be able to find what I needed on the internet, but unfortunately I can't seem to word my question generally enough.

    I'm looking for a function that is able to take data from a table (i.e. a 1 column table of different numbers), input it, one number at a time, into a formula I have elsewhere, and then take the output of the formula and write it to an adjacent table.

    This task seems simple, but I can't seem to find any formulas (or sets of formulas) that will do this for me, and I'd rather keep it in excel then have to program something from scratch.

    If this question has already been asked, I apologize in advanced. But I wouldn't know how to search for something this specific.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Function to Input sets of data, then write the output

    Can you supply a sample spreadsheet?
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Function to Input sets of data, then write the output

    Quote Originally Posted by Nater5000 View Post
    I was hoping I would be able to find what I needed on the internet, but unfortunately I can't seem to word my question generally enough.

    I'm looking for a function that is able to take data from a table (i.e. a 1 column table of different numbers), input it, one number at a time, into a formula I have elsewhere, and then take the output of the formula and write it to an adjacent table.

    This task seems simple, but I can't seem to find any formulas (or sets of formulas) that will do this for me, and I'd rather keep it in excel then have to program something from scratch.

    If this question has already been asked, I apologize in advanced. But I wouldn't know how to search for something this specific.
    A formula can only return a value to the cell the formula is located in. Formulas cannot place values in other cells.

    You could have formulas in the destination column. How that would work depends on what you are trying to calculate. Your description doesn't provide enough detail to give more specifics.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  4. #4
    Registered User
    Join Date
    07-13-2013
    Location
    New York
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Function to Input sets of data, then write the output

    For now, I'm just using this spreadsheet until I can figure out more specifically how I'm going to collect data and what have you. on the 'Black Scholes Calculator' tab, you input various pieces of information, and it returns a set of other pieces of information (as expected).

    What I'd be looking to do is keep all the information of the right side static except for the 'Stock Price' field. For this field, I want to input a set of numbers (for example, a price of 100.00, then 100.10, then 100.20, etc.), and have the opposite pieces of data (like Option premium, Option delta, etc.), be placed in a corresponding table.

    This is something I could easily do manually, but it would be very time consuming. This is why I figured there would be some sort of automated feature in excel that could do this for me. But perhaps it's not a function I'm looking for.

+ 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. (Urgent) Macro output different for different data sets - Please help
    By supershanks in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-08-2013, 07:36 AM
  2. formula: data in output cell is not changing when data in input cells are modified
    By Kuttisankaran in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-07-2013, 05:58 AM
  3. Input/Output Data
    By BabyDoc in forum Excel General
    Replies: 3
    Last Post: 08-23-2011, 09:51 PM
  4. Data Input/Output Question
    By michael.cholko in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-22-2011, 04:21 AM
  5. Matching Two sets of Data and Get a New Output Sheet
    By crapmind in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-25-2007, 03:48 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