For-loop problem in copying of cells

[desolatori]

Hello everyone. Can someone explain to me why the following code doesn't work properly?

Please Login or Register  to view this content.

What I want to do is the following: I have multiple sheets and with the first for loop I want to go through each sheet starting from sheet3.By using the second for loop i want everytime to copy the values from Sheet1 starting at 12 row and 6th column up to 15 row and 6th column and afterwards paste these values to each sheet at a specific range(I23). My problem is that the result of this code is, that it always pastes only the value which corresponds to i =15.

Thank you for your help

[Jakobshavn]

Within the For loop you are coping each of the four cell, but you are pasting them to the same location in the destination sheet!

[venkatpvc]

if i understand you correctly you dont need a second loop to copy

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Try:

Please Login or Register  to view this content.

[desolatori]

Thank you all for the replies. I think though that I didn't explain it correctly. So lets say that in Sheet 1 we have
the values from F12:F15. What i want is, to copy the value which is at cell F12 and paste it at cell I23 of sheet3, then copy the value of cell F13 and paste it at cell I23 of Sheet4 etc.With the above codes the result it to copy all the values from f12:f15 to each sheet. Sorry for the misunderstanding.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[desolatori]

Thank you very much, it works :D

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rule No. 9.


9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.