I would appreciate it very much if someone could help me with the following problem.
I have a workbook with several worksheets and want to create a new one, which will have a column with their rows containing the data from the same specific cell of these worksheets.
I´ve tried to solve this problem creating a new workbook and trying to copy the desired cells using the following command lines, without success:
for (ii=1,ii<=page.nlayers,i++) { range r1 = [BookName]$(ii)!wcol(2)[31:31]; wcol(1)[$(ii)]=r1; }
Unfortunately, this code doesn´t work but I do not understand why. Thank you! Marcelo.
There are several errors in your code, but here is the code that work:
//assume source in book1 and result in book2
range rdest = [Book2]1!wcol(1);
int nsheets = [Book1]!page.nlayers;
for (ii=1;ii<=nsheets;ii++) {
range r1 = [Book1]$(ii)!wcol(2);
rdest[ii] = r1[31];
}
Pick specific cells from different worksheets
Posted - 11/01/2020 : 5:15:07 PM
