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.
Bookmarks