The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum
 Origin Forum
 Auto fill a column with multiple sheet datas ?

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: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
polal2is Posted - 05/26/2008 : 12:31:05 PM
Origin Version (8 Pro SR2):
Operating System:(Vista SP1)

Hi, I'd like to know how can I store datas from several sheets in the same column in order to put results of several calculations together without having to copy paste manually.

For example

[Book1]Sheet1!Col(1)[1] --> [Result]Sheet1!Col(1)[1]
[Book2]Sheet1!Col(1)[1] --> [Result]Sheet1!Col(1)[2]
. .
. .
. .
[Booki]Sheet1!Col(1)[1] --> [Result]Sheet1!Col(1)[i]

" --> " = " stored in "

Thanks


Edited by - polal2is on 05/26/2008 12:32:13 PM
2   L A T E S T    R E P L I E S    (Newest First)
polal2is Posted - 05/27/2008 : 04:56:29 AM
Thanks a lot it gives me an Answer two my two posts thanks

for(ii=1; ii<=200; ii++)
{
range source = [book1]sheet1!col(1);
range output = [book3]sheet1!col(2);
output[ii] = source[ii+1];
}

for this problem is working fine
larry_lan Posted - 05/27/2008 : 04:16:28 AM
Hi:

Maybe you can write some script like:

for(ii=1; ii<=3; ii++)
{
	range source = [book$(ii)]sheet1!col(1);
	range output = [Result]sheet1!col(1);
	output[ii] = source[1];
}


Thanks
Larry
OriginLab Technical Services

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000