Currently, I have a macro report to pull tests from a database which is hard-coded and would like it so the end user can change the values on the tests in Sheet1 and the formula will change.
Example:
Sheet1:
<tbody>
</tbody>
Within the macro where it extracts it from the database via SQL query, I have it hard-coded but would like to change it so it pulls it via the values of column B in 'Sheet1'
Example:
Sheet1:
Test #1 | 4846 |
Test #2 | 65489 |
Test #3 | 1289 |
<tbody>
</tbody>
Within the macro where it extracts it from the database via SQL query, I have it hard-coded but would like to change it so it pulls it via the values of column B in 'Sheet1'
Code:
SQLquery = SQLquery & " Where t.TS_TEST_ID = '[B]4846[/B]' OR t.TS_TEST_ID = '[B]65489[/B]' OR t.TS_TEST_ID = '[B]1289[/B]' "