Hello, I'm pretty new to Origin and I was searching for an answer but couldn't find anything. Although, I guess it should be something very common to do. I have a bunch of data in my first worksheet and I would like to have the slightly modified data in my second one. Therefore, I wanted to use "set column values..." and then I tried something like "Sheet1!B" in all kinds of variations to access the data of my B column in my first worksheet but nothing seems to work. I found something where it sais I have to use the menu "variables" in "set column values...". However, the menu "variables" doesn't exist.
Could anyone help me out? Shouldn't be that big of a deal to access data from another worksheet or is it?
thanks a lot for your help!
Origin Ver. and Service Release (Select Help-->About Origin): 8 Operating System: Windows
I am using 8.5 and I have 'Variables' tab when set column value and also a 'Before Formula script' window where shows the variables. If you have neither of them, I guess you might use some simple scripts to do so. So please open 'Script window' from 'Window'. And try like this:
range r1 = [Book1]Sheet1!A; range r2 = [Book2]Sheet1!B; r2=5*r1;
Then you will set Column B of Book2 sheet1 to be 5 times of Column A of Book1 sheet1.
Access data from another worksheet
Posted - 05/29/2013 : 10:36:06 AM
