I would like to extract data from several worksheets (of the same structure) in one workbook and save it in another worksheet/workbook. Each source worksheet consists of two columns: col(A) (=X) and col(B) (=Y). I would like to get the value of col(B) at a certain, fixed value of col(A), save this to the output worksheet, then get the next value from the following source worksheet, save it and so on. The fixed value (=X) might not be one of the values of col(A), i.e. interpolation would be required.
In principle this is easy; one can use col(B)(x), if the column designations are set accordingly. However, this only works for the active worksheet.
I have tried to use the range command, but from what I can see this only lets me access the value of col(B) at a certain index, but not the value of col(B) that corresponds to a random, fixed value of col(A). Hence my question is if there is a version of the col(B)(x) command that lets me specify in which workbook/worksheet this col(B) is to be found?
Any help is appreciated.
-- Origin Ver. and Service Release (Select Help-->About Origin): OriginPro 8.5.0 SR1 Operating System: Win 7 (64 bit)
Extract col(B) vs col (A) from another worksheet
Posted - 12/22/2011 : 8:06:28 PM
