Hello,
I am new to programming and want to iterate a loop and output certain information each time.
I have many rows of data in different spreadsheets that are all different lengths. I need to see if some of the columns in the row of data meet a certain discipline, i.e. one column <-2 or one that is <0 or two that both must be <0.
I was planning on using if then statements to see if the row matched the criteria, but then if it matches the criteria i need to export this information (i.e. which column matched the criteria) to another worksheet (or run the program in a certain worksheet and get the information from the other worksheets and export it into the current one)
but then i need the loop to go onto the next line and repeat the process. until there are no more lines of information. There is a final summary line that I was thinking about doing " loop until strHeader="total" " or something like that.
Sorry if this is vague, thanks for the help!
I am new to programming and want to iterate a loop and output certain information each time.
I have many rows of data in different spreadsheets that are all different lengths. I need to see if some of the columns in the row of data meet a certain discipline, i.e. one column <-2 or one that is <0 or two that both must be <0.
I was planning on using if then statements to see if the row matched the criteria, but then if it matches the criteria i need to export this information (i.e. which column matched the criteria) to another worksheet (or run the program in a certain worksheet and get the information from the other worksheets and export it into the current one)
but then i need the loop to go onto the next line and repeat the process. until there are no more lines of information. There is a final summary line that I was thinking about doing " loop until strHeader="total" " or something like that.
Sorry if this is vague, thanks for the help!