Macro - enter data in next clear row after every run

[maryam_husn]

Hello, I have a question that is similar to ones asked before but succinctly different.

i have a macro that
- copies rows from one sheet into another sheet based on a set of criteria
- the very very very first time the macro is run, the first row of data should be put into row 7 (formatting reasons)
- however, every other time it's run it should paste into the next clear row.

but, what is happening is that, each time its run, it puts the data into row 7 => overwriting data.

i've used the offset and counter function but perhaps I need to put it in the header of the code to get it working?
i don't know how to do this.

my code pasted below:

Please Login or Register  to view this content.

[Rupeshpatil]

Hii Maryam,

please check "Use relative reference" on while recording macro

secondly .. Finish your macro by clicking on the cell below your current row in which macro pasted the data. (use offset function)

It works when I run the similar kind of macro.

Regards,
Rupesh

[maryam_husn]

Hello Rupesh,

thank you for your comment.
i'm sorry, but i don't follow

could you direct me to the line of code that needs changing?

thanking you & regards,
maryam.

[Rupeshpatil]

Is it possible for you to share the original file in which macro has been recorded and stored

rupesh

[maryam_husn]

hi rupesh,
thank you.
please find attached.
regards,
Attachment 328762