Assigning values from 1 wb to another using arrays

hi

I'm just trying to assign values from Book1 to Book2 but my code isn't working and I don't know where i got it wrong. I don't know if it has to do with my declaration , if the syntax is even correctly put.

Attached are the samples and code, if anyone could take a look & give me a hand with it, really appreciate it.


Stewart

hi 6StringJazzer

here's the result i hope to achieve in Book2, sorry i didn't include this in my 1st post. The sequence is the same as mentioned in my draft code

Stewart

the code works a charm, thanks Dante

Stewart

hey sintek,

i tried to apply your loop-free code but i think maybe because you had set a limit to the last row (though I couldn't locate where), when I expand the data size (downward add rows), your code does not include them beyond my sample last row and the additional data do not get assigned to Book2. The sample wb Book1 was just a simplified book as the actual data population is much larger

Could you let me know where that limit is so i can try to apply your code again ? I'm hoping to test for the much larger data population, your loop-free is always good

Stewart

That's marvellous Sintek

thanks again,
Stewart