Use cells in different files IN excell

Closed
maryam1360 Posts 2 Registration date Tuesday August 19, 2008 Status Member Last seen August 20, 2008 - Aug 20, 2008 at 12:04 AM
maryam1360 Posts 2 Registration date Tuesday August 19, 2008 Status Member Last seen August 20, 2008 - Aug 20, 2008 at 06:11 AM
Hello,
Hello,
H have different files named 110.xlc...1980.xlc...1020... and the final file there is a column in it . the value of it select as name of files 110...1020....
I want to selcet and set the value of rows from the file witch have same name first colum

eg
col1 col2 col3
110 (HERE cells in 110.xlc)
400 (HERE CELLS 400.XLC
300

regards
maryam

1 response

crystal.me Posts 11 Registration date Sunday August 17, 2008 Status Member Last seen February 21, 2009 2
Aug 20, 2008 at 05:49 AM
hi there,

i cant understand what you are trying to do but as far as i can understand cant you copy and paste the cells?
0
maryam1360 Posts 2 Registration date Tuesday August 19, 2008 Status Member Last seen August 20, 2008
Aug 20, 2008 at 06:11 AM
Hi
there are more than 58 files and in each file 12 cells . if i use copy paste it takes more than 3 hours.
for your information ...
I want to collcet forms in excel in 58 branches (it contains statistics ) every week .
i use paste link for it...but it takes much time in large number...if you have better way ...say how ican do it.

thanks
0