copy range A4:A100 and paste on another workbook's sheet but one by one

hello
i want to copy a range of sheets("name").range("a4:a100) and paste on another workbook sheets("name").range("a4:a100"), but one by one
e.g

sheets("name").range("A4:A100).copy
and paste new workbook with
sheets("name").range("A4:A100")
first paste a4
secondly paste a5
third paste a6
forth paste a7
....paste a100

thanx

Use a loop replacing (1-100) with 'i'.

What are the reasons behind doing it this way as opposed to in one block?

Hello TKCZBW

i m using below code worksheet change event on my sheets("TO.")
what does below code?
when i enter a value in C4 then this generate auto formulas for me, but if i paste here data in range then this is giving a debug and formulas are not generating, so i want to paste here one by one entry,.....plz provide a code with loop
thanx

Please Login or Register  to view this content.

In brief . . .

Please Login or Register  to view this content.

sorry TKCZBW
i m not able to make full code
plz make full code with range

copy = sheets("to.").range("c4:c34")
and
paste = sheets("to.").range("c4:c34")

Sorry, that's really a separate question to your initial one, but it is answered above as well. I cannot make the full code, as I cannot fuly understand the code you have already written in terms of what you want it to achieve and what results you expect.

Select the range as I have described above and then copy. Then select your landing range, in the same way as your 'from' range. then selection.paste.