Copy particular cells of a row to another worksheet if cell value = x

[Jhemz Celis]

Hi Guys,

Kindly help me with this one. I have a macro in the System Network worksheet that copy particular cells of a row if the value of a cell = Network Attack to another worksheet named Attack Report.

It's working as of this moment, but my problem is everytime the macro is run, it copies also the previously copied cells resulting into duplicates. What I want to do is when the macro runs, it skips the previously copied cells and only copy those that are not copied yet. Also, is there a way to put a button in the worksheet that will run the macro?

Please Login or Register  to view this content.

Please see attached file for your reference.


Thanks in advance

[Mordred]

The code needs a way to know it has already been copied. Your title mentions an X but you don't have any cells that actually have an X in them. This is a good idea but where would you want it? If I would guess, I would say you'd want it and the last cell in that row, on the right, right? If so, try:

Please Login or Register  to view this content.

[Jhemz Celis]

The code needs a way to know it has already been copied. Your title mentions an X but you don't have any cells that actually have an X in them. This is a good idea but where would you want it? If I would guess, I would say you'd want it and the last cell in that row, on the right, right? If so, try:

Please Login or Register  to view this content.

Hi Mordred, thanks for replying. I tried the code you provided but still does the same thing. Everytime the macro is run, it copies the needed data all over again. Is there a way to skip the data copied by the previously ran macro?