Hello! I have several worksheets with similar names, e.g. wks1, wks2, wks3.... Each worksheet includes several columns also with similar names, e.g. data1, data2, data3....
I am wondering if I can somehow replace number in the names with "i" and make a loop? I imagine it could be like this (but with correct syntax):
for (i = 1; i <= 5;i ++) { for (ii = 1; ii <= 10;ii ++) { wks10_results{i}=wks{i}_data{i}/wks{ii}_data{ii}; };};
I have the same problem but I do not understand the proposed solution. Could you please write the whole code? To my specific problem: I have 16 columns which shall be named "Pix 1" to "Pix 16", so I would like to combine the string "Pix" with an integer increment.
variable number in worksheet and column name
Posted - 09/25/2012 : 1:20:54 PM
