+ Reply to Thread
Results 1 to 1 of 1

Brining in 2 inputs incrementally & 2 others from lists.

  1. #1
    Registered User
    Join Date
    02-17-2018
    Location
    United Kingdom
    MS-Off Ver
    2013
    Posts
    20

    Exclamation Brining in 2 inputs incrementally & 2 others from lists.

    Hi,

    I have the following code which brings in 2 inputs (v, q) incrementally (max, min and inc values specified in workbook) and also brings in 2 other inputs from lists (d and Fs, stated in workbook columns) in the following fashion. There are 3 values of v and q, and 5 values for d and Fs. So there are 45 solutions (3 * 3 * 5) as d and Fs change at the same time.

    v1 d1 Fs1 q1
    v2 d1 Fs1 q1
    v3 d1 Fs1 q1
    v1 d2 Fs2 q1
    v2 d2 Fs2 q1
    v3 d2 Fs2 q1
    v1 d3 Fs3 q1
    v2 d3 Fs3 q1
    v3 d3 Fs3 q1
    v1 d4 Fs4 q1
    v2 d4 Fs4 q1
    v3 d4 Fs4 q1
    v1 d5 Fs5 q1
    v2 d5 Fs5 q1
    v3 d5 Fs5 q1
    v1 d1 Fs1 q2
    v2 d1 Fs1 q2
    v3 d1 Fs1 q2
    v1 d2 Fs2 q2
    v2 d2 Fs2 q2
    v3 d2 Fs2 q2
    v1 d3 Fs3 q2
    v2 d3 Fs3 q2
    v3 d3 Fs3 q2
    v1 d4 Fs4 q2
    v2 d4 Fs4 q2
    v3 d4 Fs4 q2
    v1 d5 Fs5 q2
    v2 d5 Fs5 q2
    v3 d5 Fs5 q2
    v1 d1 Fs1 q3
    v2 d1 Fs1 q3
    v3 d1 Fs1 q3
    v1 d2 Fs2 q3
    v2 d2 Fs2 q3
    v3 d2 Fs2 q3
    v1 d3 Fs3 q3
    v2 d3 Fs3 q3
    v3 d3 Fs3 q3
    v1 d4 Fs4 q3
    v2 d4 Fs4 q3
    v3 d4 Fs4 q3
    v1 d5 Fs5 q3
    v2 d5 Fs5 q3
    v3 d5 Fs5 q3



    Please Login or Register  to view this content.
    This code works at intended. However, I wish to modify it so there is now an extra term being brought in from a list, but not at the same time as before. The inputs should be brought in as follows (where v and E are brought in incrementally, d and Fs are brought in at the same time from different lists, and q is brought in from a separate list at different times).

    v1 d1 Fs1 q1 E1
    v2 d1 Fs1 q1 E1
    v3 d1 Fs1 q1 E1
    v1 d2 Fs2 q2 E1
    v2 d2 Fs2 q2 E1
    v3 d2 Fs2 q2 E1
    v1 d3 Fs3 q3 E1
    v2 d3 Fs3 q3 E1
    v3 d3 Fs3 q3 E1
    v1 d4 Fs4 q4 E1
    v2 d4 Fs4 q4 E1
    v3 d4 Fs4 q4 E1
    v1 d5 Fs5 q5 E1
    v2 d5 Fs5 q5 E1
    v3 d5 Fs5 q5 E1
    v1 d1 Fs1 q6 E2
    v2 d1 Fs1 q6 E2
    v3 d1 Fs1 q6 E2
    v1 d2 Fs2 q7 E2
    v2 d2 Fs2 q7 E2
    v3 d2 Fs2 q7 E2
    v1 d3 Fs3 q8 E2
    v2 d3 Fs3 q8 E2
    v3 d3 Fs3 q8 E2
    v1 d4 Fs4 q9 E2
    v2 d4 Fs4 q9 E2
    v3 d4 Fs4 q9 E2
    v1 d5 Fs5 q10 E2
    v2 d5 Fs5 q10 E2
    v3 d5 Fs5 q10 E2
    v1 d1 Fs1 q11 E3
    v2 d1 Fs1 q11 E3
    v3 d1 Fs1 q11 E3
    v1 d2 Fs2 q12 E3
    v2 d2 Fs2 q12 E3
    v3 d2 Fs2 q12 E3
    v1 d3 Fs3 q13 E3
    v2 d3 Fs3 q13 E3
    v3 d3 Fs3 q13 E3
    v1 d4 Fs4 q14 E3
    v2 d4 Fs4 q14 E3
    v3 d4 Fs4 q14 E3
    v1 d5 Fs5 q15 E3
    v2 d5 Fs5 q15 E3
    v3 d5 Fs5 q15 E3

    Please Login or Register  to view this content.
    Above is my attempt for the modification, but I am unsure how to allow for 'q' to be brought in as intended.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Incrementally increase
    By allgeef in forum Excel General
    Replies: 2
    Last Post: 03-09-2017, 08:37 PM
  2. Prioritizing conditional lists and data validation inputs
    By Jester1405 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 09-30-2014, 07:49 PM
  3. Replies: 0
    Last Post: 06-16-2013, 10:46 AM
  4. Increase Incrementally
    By otgs2 in forum Excel General
    Replies: 6
    Last Post: 01-17-2012, 04:24 AM
  5. Reset Dropdown Lists based on Other inputs / cells
    By jonreynolds in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-12-2009, 12:20 PM
  6. [SOLVED] Vlookups in a Pivot table brining back OFFSET Data
    By tlk40us in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-20-2006, 01:55 PM
  7. Brining the Grid Forward
    By Printman in forum Excel General
    Replies: 0
    Last Post: 01-13-2005, 02:36 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