One spreadsheet for an array of inputs

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Well - I've not figured out where to put the variables - it would, I think, be better to just do the calculation in core

A few thoughts:

1) Probably the "easiest" approach that I see at this point is to make multiple copies of the "Spreadsheet" tab (right click on sheet tab -> move or copy... -> fill out dialog), then adjust the references in each copy of spreadsheet to refer to a different row in "Input&Output". The references in column K of "Input&Output" will need to refer to the appropriate copy of the "Spreadsheet" tab. It will be a little tedious, but it should not take terribly long to make 15 or so copies of "Spreadsheet" and adjust the references.

2) IMO, one of the fundamental aspects of spreadsheet programming is arranging calculations so that you can take full advantage of "copy and paste". The calculations in "Spreadsheet" is currently arranged in three visually appealing blocks of cells, but this does not make it easy to "copy and paste" to get copies of the same calculation. It will be less visually appealing, but I would recommend that you spend some time with "Spreadsheet" and arrange the calculation(s) so that a complete calculation for a single set of inputs occurs in a single row. If you pay careful attention to relative and absolute references, then it should be a simple "copy and paste" operation to obtain the same calculation for subsequent rows. This is the kind of strategy I use a lot -- Pay attention to how you arrange calculations that you will want to be able to repeat so that it will be easy to copy and paste those calculations.

Neither of those use VBA. Other ideas that use VBA:
3) For some frequently used calculations, I like to build a User-Defined Function (UDF) that I can use in the spreadsheet just like any of the built in functions. This requires an investment of time upfront to build and debug the UDF. Once the UDF is programmed, though, it is as simple as entering the UDF (with appropriate attention to arguments and relative and absolute referencing like any other function) into the output cell.

4) I never use this strategy, but I do see some who will write a VBA macro/Sub procedure that will write the inputs from "Input&Output" into the appropriate cells in "Spreadsheet", allow the calculation to finish, then write the result(s) into the appropriate cell(s) in "Input&Output". I am not fond of this strategy, but some people like it.

Which of these strategies would you like to use, or do you have another strategy you would prefer to try? Where do you get stuck in implementing that strategy.

That can be done with a data table:

	E	F	G	H	I	K	L	M
2	Input to data table
3	1	2.24	0.60	40.41	864.97	<< Selected set of inputs
4	Inputs
5	Time Stamps	Pressure	DelP	Temperature	CV
6		BarA	kPA	C			22,843	<< prototype formula
7	07-Jul-17 00:00:00	2.24	0.60	40.41	864.97	1	22,843
8	07-Jul-17 00:05:00	2.23	0.55	40.21	842.17	2	21,592
9	07-Jul-17 00:10:00	2.26	0.62	40.03	694.48	3	18,787
10	07-Jul-17 00:15:00	2.22	0.56	39.93	693.59	4	18,008
11	07-Jul-17 00:20:00	2.37	0.49	39.84	579.53	5	15,081
12	07-Jul-17 00:25:00	2.30	0.44	39.75	616.67	6	15,128
13	07-Jul-17 00:30:00	2.22	0.56	39.66	484.07	7	12,651
14	07-Jul-17 00:35:00	2.31	0.45	39.57	794.09	8	19,562
15	07-Jul-17 00:40:00	2.28	0.59	39.47	857.67	9	22,854
16	07-Jul-17 00:45:00	2.36	0.58	39.38	864.95	10	23,477
17	07-Jul-17 00:50:00	2.22	0.52	39.29	864.95	11	21,742
18	07-Jul-17 00:55:00	2.31	0.44	39.20	864.95	12	21,074
19	07-Jul-17 01:00:00	2.30	0.51	39.11	861.17	13	21,994
20	07-Jul-17 01:05:00	2.21	0.53	39.01	811.70	14	20,502
21	07-Jul-17 01:10:00	2.25	0.59	38.92	802.36	15	21,263

Very nice, shg. Easier than anything I had suggested.

Gracias, MrS.

You're welcome.

You're welcome, and thanks for a very clear explanation.

There's a PDF that I use to refresh myself on data tables in the thread at https://www.excelforum.com/tips-and-...ta-tables.html.