VBA to create a custom table

[pyclen]

Hi All,

Before I provide a specific generalized example I would like to ask this great community whether it is possible to make a script in VBA that will ask the user for input, and then based on the input provided generate a table which will be used for a cost calculation on either the same or a different sheet.

Input required would include
Temperature/humidity, i.e. 25C/60%RH, there are usually 3 combinations
Length of time in months for each combo, and lastly what test is performed at each time and temperature/humidity combo

I am happy to provide a generic sample table
Any help is appreciated

 

[pyclen]

below is an example of a table I want to generate

Condition 1, 2, 3 correspond to various temperature/humidity combinations (25C/60% RH for example)

T1 - T10 are various timepoints (in months) from T1 that samples get tested using Test 1, 2, 3, 4 (I am trying to be a general as possible here so people can get a better understanding)

Tests shown for condition 2 are optional, and only executed when either or both of the other conditions fails (this can be addressed in a separate table if necessary using the same input script)

This table then serves as source for the calculation of how much it cost to test at any given timepoint

What I would like in a VBA script is to ask users to

1. define conditions 1, 2, 3 (one is optional, so could be in a separate inquiry) by either selecting them from a dropdown (not shown in example) or typing (25C/60% RH for example)
2. define timepoints besides initial, either again manually typing or selcting them from a dropdown
3. define what is tested at what condition and timepoint
4. after the user inoput a table like shown below is generated

I know that is a big ask (maybe too big) but I hope someone can answer maybe something like that is feasible or not
Thank you

Book1
	C	D	E	F	G	H	I	J	K	L	M	N
2
3		storage condition	time [months]
4			T1	T2	T3	T4	T5	T6	T7	T8	T9	T10
5		condition 1	a,b,c,d	a,b	a,b	a,b	a,b	a,b,c,d	a,b	a,b,c,d	a,b,c,d	a,b,c,d
6		condition 2		(a,b)	(a,b)	(a,b)	(a,b)	(a,b,c,d)
7		condition 3		a,b	a,b	a,b,c,d
8
9
10		T1 --> T10		T1 = initial		a =	Test 1
11		1				b =	Test 2
12		2				c =	Test 3
13		3				d =	Test 4
14		6
15		9
16		12
17		18
18		24
19		36
20		48
Sheet1