G
Guest
Using XL 2000
My worksheet contains 20 columns, A:T. The cells in each column (from row 2
down) contain either a "True" or "False" phrase.
I need a routine to loop through the 20 columns a row at a time.
Row 1 contains random text phrases.
Example;
Starting in Row 2, where the cell content in the first column (A) equals
"True", add the cell content in row 1 (A1) to a variable called CellString.
Continue, adding the content in B1, C1, D1 etc to CellString where the above
condition is met until the loop completes for that row.
When the loop for each row finishes I will transfer the content of
CellString to another cell in a different worksheet.
The loop repeats for as long as there is data in each row.
Any ideas appreciated.
Thanks, Paul
My worksheet contains 20 columns, A:T. The cells in each column (from row 2
down) contain either a "True" or "False" phrase.
I need a routine to loop through the 20 columns a row at a time.
Row 1 contains random text phrases.
Example;
Starting in Row 2, where the cell content in the first column (A) equals
"True", add the cell content in row 1 (A1) to a variable called CellString.
Continue, adding the content in B1, C1, D1 etc to CellString where the above
condition is met until the loop completes for that row.
When the loop for each row finishes I will transfer the content of
CellString to another cell in a different worksheet.
The loop repeats for as long as there is data in each row.
Any ideas appreciated.
Thanks, Paul