| T O P I C R E V I E W |
| cengelhard |
Posted - 06/21/2005 : 01:30:48 AM
Origin Version (Select Help-->About Origin): 7.5 SR5
Operating System: WinXP SP2
I am sorry, I am pretty new to Origin. I searched the forum, but maybe my question is to simple:
I have two worksheets (WS1, WS2) with 500 columns, 80 rows.
I would like to create a third worksheet WS3 with data in each column multiplied like this: WS1_column1 * WS2_column1
How could it be done automatically (loop..) without "set values.." manually?
Thanks for any reply,
Carsten |
| 1 L A T E S T R E P L I E S (Newest First) |
| Leo_Li |
Posted - 06/21/2005 : 06:55:11 AM
Assume names of your source worksheets: Data1, Data2; and destination: Data3. Paste the following codes to the script window.
Select the three lines of code and press Enter.
for (j = 1; j <= wks.nCols; j++)
for (i = 1; i <= wks.nRows; i++)
Data3!cell(i,j)=Data1!cell(i,j)*Data2!cell(i,j);
|
|
|
