| T O P I C R E V I E W |
| SevLaur19 |
Posted - 10/20/2021 : 2:09:55 PM
Hi,
I'm wondering if there is a way to subtract a reference data set from a number of different workbooks in one go. As far as I see, I can only add a single input (selecting more does not work) and manually doing this for hundreds of workbooks is tedious and prone to errors. Is there a smart way to do this?
Thanks!
Origin Ver. Origin Pro 2020 and Service Release: 9.7.0.188
Operating System: Windows 10
LS |
| 1 L A T E S T R E P L I E S (Newest First) |
| snowli |
Posted - 10/20/2021 : 5:12:33 PM
You can write a script to loop through all books and subtract col B of each book with col A in Sheet1 of Book1
Choose Window: Script window and put the following code in. Highlight all and press Enter key
range ref=[book1]1!1;
doc -e LB {
col(B)=col(B)-ref;
}
Thanks, Snow
|
|
|
