Results 1 to 15 of 15

Need VBA code that applies multiple sets of inputs to model and pastes each set of values

Threaded View

ascheetz1 Need VBA code that applies... 03-20-2023, 11:33 AM
beyond Excel Re: Need VBA code that... 03-20-2023, 02:02 PM
ascheetz1 Re: Need VBA code that... 03-21-2023, 01:09 PM
beyond Excel Re: Need VBA code that... 03-21-2023, 05:37 PM
ascheetz1 Re: Need VBA code that... 03-21-2023, 05:42 PM
beyond Excel Re: Need VBA code that... 03-22-2023, 01:03 AM
ascheetz1 Re: Need VBA code that... 03-22-2023, 10:59 AM
beyond Excel Re: Need VBA code that... 03-22-2023, 12:49 PM
ascheetz1 Re: Need VBA code that... 03-22-2023, 02:10 PM
beyond Excel Re: Need VBA code that... 03-22-2023, 02:21 PM
ascheetz1 Re: Need VBA code that... 03-22-2023, 02:23 PM
beyond Excel Re: Need VBA code that... 03-22-2023, 02:43 PM
beyond Excel Re: Need VBA code that... 03-22-2023, 02:49 PM
ascheetz1 Re: Need VBA code that... 03-22-2023, 02:53 PM
beyond Excel Re: Need VBA code that... 03-22-2023, 03:08 PM
  1. #1
    Registered User
    Join Date
    03-20-2023
    Location
    New York, NY
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2302) 32-bit
    Posts
    22

    Need VBA code that applies multiple sets of inputs to model and pastes each set of values

    I am trying to take a data set which comprises many different sets of inputs, and run those inputs through a model on a separate sheet and return the relevant outputs back to the data set sheet, and then move to the next row and do the same.

    I've attached a sample excel file for context - the inputs to be applied to the "Model" sheet are found on the "Data Tape" sheet - each row in the "Data Tape" sheet represents a different scenario. The outputs to be pasted to columns E:G in "Data Tape" are cells C10:C12 of "Model" sheet.

    The end result should be a fully populated Data Tape sheet that ties with the "checks" to the right. This will need to be stable for a few hundred rows without crashing. Really appreciate any help - thank you.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Suggested vba code that applies to multiple check boxes
    By Romela in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-12-2020, 08:12 PM
  2. Trying to build a model with dates as inputs.
    By misterv in forum Excel General
    Replies: 3
    Last Post: 11-14-2019, 09:02 AM
  3. Obtaining set of outputs for multiple sets of inputs
    By rypalan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-30-2019, 12:06 PM
  4. VBA Code copies and pastes the formulas? I only need the values.
    By tysonbly in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-14-2015, 11:20 AM
  5. [SOLVED] Addition to code to copy and pastes special values and cell format, but not links.
    By singerbatfink in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-13-2014, 03:10 PM
  6. Replies: 1
    Last Post: 10-03-2012, 07:06 PM
  7. Replies: 2
    Last Post: 09-05-2012, 03:20 PM

Tags for this Thread

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