Forum Discussion
tristaanogre
14 years agoEsteemed Contributor
Do the modules in Test1 and Test2 also use data from the spreadsheet?
A suggestion:
1) Add a column to your data rows in your spreadsheet to indicate what "kind" of test it is. I'm assuming that these different tests are rather standardized as well.
2) Add If/Then logic to your JJ7 module to check that new column and then, depending upon what the new column contains, execute the appropriate code.
What you'll have, then, is encapsulated all in one module all the necessary code execution that you need and it will all be driven by the data in the sheet. Depending upon what row is being processed is what additional code will be executed.
A suggestion:
1) Add a column to your data rows in your spreadsheet to indicate what "kind" of test it is. I'm assuming that these different tests are rather standardized as well.
2) Add If/Then logic to your JJ7 module to check that new column and then, depending upon what the new column contains, execute the appropriate code.
What you'll have, then, is encapsulated all in one module all the necessary code execution that you need and it will all be driven by the data in the sheet. Depending upon what row is being processed is what additional code will be executed.