How would I set up and configure a useform for the following example:
I have input all the conditions in an array one one sheet from a1 to v10000
I've arranged the data in blocks of 100 as below:
Row 1
A1 (1) B1 (1) C1 (1)
Row 2
A1 (1) B2 (2) D2 (1)
Row 3
A1 B1 C1 D1 E1
1 3 1
Row 4
A1 B1 C1 D1 E1 F1
1 4 1
Row 5
> etc
Row 100
A1 B1 C1 D1 E1 F1 ……. V1
1 100 1
Row 101
A1 B1 C1
2 1 1
(then as for rows 1 to 100, but with a 2 in Col A101-A201)
> etc
Incrementing by 1 in Col A until:
Row 10000
A1 B1 C1 D1 E1 F1 ……. V1
100 100 1
I would like to have an input box for these 3 criteria:
Col A= No. of recipients (of email) from 1 to 100 (1 = recipient 1 ... 100 = recipient 100)
Col B= No. of emails to each recipient (1 = 1 email ... 100 = 100 emails)
Cols C:V = Criteria for email from 1 to 20 (a 1 in col C = criteria 1, a 1 in Col V = Criteria 20)
The output from the above selections from the input box should result in the following inputs to Col W:
For Row 1
A1 B1 C1
1 1 1
Output would be a 1 in W1
Row 2
A1 B1 C1 D1
1 2 1
Output would be a 2 in W2
Row 10000
A1 B1 C1 D1 E1 F1 ……. V1
100 100 1
Output would be a 10000 in W10000
Many thanks!
<< PreviousPage <input id="goToPageNum" value="2" type="text"> of 2Next >>
I have input all the conditions in an array one one sheet from a1 to v10000
I've arranged the data in blocks of 100 as below:
Row 1
A1 (1) B1 (1) C1 (1)
Row 2
A1 (1) B2 (2) D2 (1)
Row 3
A1 B1 C1 D1 E1
1 3 1
Row 4
A1 B1 C1 D1 E1 F1
1 4 1
Row 5
> etc
Row 100
A1 B1 C1 D1 E1 F1 ……. V1
1 100 1
Row 101
A1 B1 C1
2 1 1
(then as for rows 1 to 100, but with a 2 in Col A101-A201)
> etc
Incrementing by 1 in Col A until:
Row 10000
A1 B1 C1 D1 E1 F1 ……. V1
100 100 1
I would like to have an input box for these 3 criteria:
Col A= No. of recipients (of email) from 1 to 100 (1 = recipient 1 ... 100 = recipient 100)
Col B= No. of emails to each recipient (1 = 1 email ... 100 = 100 emails)
Cols C:V = Criteria for email from 1 to 20 (a 1 in col C = criteria 1, a 1 in Col V = Criteria 20)
The output from the above selections from the input box should result in the following inputs to Col W:
For Row 1
A1 B1 C1
1 1 1
Output would be a 1 in W1
Row 2
A1 B1 C1 D1
1 2 1
Output would be a 2 in W2
Row 10000
A1 B1 C1 D1 E1 F1 ……. V1
100 100 1
Output would be a 10000 in W10000
Many thanks!
<< PreviousPage <input id="goToPageNum" value="2" type="text"> of 2Next >>
Last edited:
