The Origin Forum

The Origin Forum

All Forums

Origin Forum

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:

UserName:

Password:

Anti-Spam Code:

Format Mode:

Format:

Message:

* HTML is OFF
* Forum Code is ON

Check here to include your profile signature.
Check here to subscribe to this topic.

T O P I C R E V I E W
Mik95	Posted - 03/11/2021 : 1:04:46 PM OriginProm2018 (64bit) SR1 b9.5.1.195 Hi everyone! I searched a lot for similar questions in this forum but didn't find anything. I have 12 workbooks, each one with 25 worksheets. I should multiply the column (E) of each worksheet in each workbook by a constant *5.73. Is there any command to do this process at once? Thanks!
2 L A T E S T R E P L I E S (Newest First)
Mik95	Posted - 03/11/2021 : 4:34:37 PM quote: Originally posted by YimingChen Go to menu Window->Script Window, enter the script below, highlight all and hit Enter to run. doc -e LB { col(E) = col(E)*5.73; } Note: This operation will apply to all sheets in all workbooks and matrixbooks in the project. James Thank you James!
YimingChen	Posted - 03/11/2021 : 2:07:52 PM Go to menu Window->Script Window, enter the script below, highlight all and hit Enter to run. doc -e LB { col(E) = col(E)*5.73; } Note: This operation will apply to all sheets in all workbooks and matrixbooks in the project. James

The Origin Forum