Paste to a Dynamic range

[abhitullu]

I want to copy a particular row (one that meets the "IF" criteria) from one workbook and paste it to a particular tab of another workbook. In the another workbook, where I intend to paste the copied row, I want to do it over a dynamic range,wherein I can vary the row number after completion of every "IF" loop.

To do this I wanted to specify the cell locations in the range where the copied stuff is to be pasted.Here I want to keep incrementing the row by one unit every loop but want to keep the column number fixed.

I am pasting the code below:

Please Login or Register  to view this content.

[pike]

Hi abhitullu

with the "Cardine5H.xlsx" open

Please Login or Register  to view this content.

[abhitullu]

Thanks.

The code pastes the selected stuff to the Cardine5H.xlsx sheet's specified worksheet but starts from the very first row.
If I want to specify the row, from where it should start pasting the stuff, what should I do?

[pike]

Hi abhitullu
for start in row 20

untested but try...

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

or put a 1 in cell a19

[abhitullu]

not working.

[pike]

try..

Please Login or Register  to view this content.

[abhitullu]

The first code where you had used offset worked fine if I run the macro only once.

But if i update my master sheet from where I am copying stuff and then re-run the macro, the code starts pasting (Cardine5H.xlsx sheet) to the first row which is empty and not the very first row (as was the case in the first run).so, what should I do? I want that no matter what whenever I run the macro it should start pasting from the specified row (here the first row) and go downwards.

[abhitullu]

Thanks.Everything is working fine now.