| T O P I C R E V I E W |
| sarastokes |
Posted - 12/31/2014 : 12:29:14 PM
Origin Ver. and Service Release (Select Help-->About Origin):
Operating System: win7
I was wondering if there is an way to write code for changing the parameters of existing rowstats output columns.
I currently have a book for each test group containing the source data (with 5 sheets for different test conditions). Then I have another book where each test condition worksheet contains the rowstats output for each group.
My original rowstats function selected data using
irng:=col(B)[1]:col(end)[4002]
I was hoping that the auto recalculate setting would adjust the average as I add new columns of data but it appears I need to change the parameters each time I add more columns. Manually editing the parameters of all my averages each time I have new data would be tough so I am looking for a way to code it.
Thank you for your time |
| 6 L A T E S T R E P L I E S (Newest First) |
| jenniferdavid |
Posted - 02/19/2015 : 02:09:21 AM
Thank you (lkb0221) for sharing the valuable information.
[url=http://www.mccal.com/loans.php]Merchant Cash Advance[/url] |
| FannieBrown |
Posted - 02/11/2015 : 12:12:33 AM
It is possible.
Fannie
|
| sarastokes |
Posted - 01/05/2015 : 11:20:12 AM
Thank you. That works if I delete the existing average columns first. |
| lkb0221 |
Posted - 01/02/2015 : 12:18:15 PM
Hi,
I think you can try using Worksheet:Worksheet Script, with Run Script: Upon Changes in Range(s) be 1:end.
Zheng
OriginLab |
| sarastokes |
Posted - 01/02/2015 : 11:45:43 AM
Potentially but it would be much easier to continue using columns as I like putting information in the units and comments row and occasionally use sparklines. |
| lkb0221 |
Posted - 01/02/2015 : 10:17:29 AM
Hi,
Is that possible to transform your data structure so that when new data coming in, it would be new rows, instead of new column?
Zheng
OriginLab |
