change code form implementation in the same file to external file to copy lastrow

Hi
I want to copy the data after the last row containing a zero for column G of each name of column C , and ignore all the data that precedes the last row with a zero for the same name if the last row contains a zero for column G for a specific name . if there are no data under it the last row with a zero , then it should be ignored and not copied But if there is absolutely no last row that contains a value of zero for a specific name, then all the data for the name is copied.
I put what I want the result in accounts sheet for the file 2023 and import from filter sheet for BOX1 file . should replace data every time run the macro .
here is Marc L's code works in the same file in CLEAN sheet( but delete clean sheet to implement in other file ) .

Please Login or Register  to view this content.

Hi,

attach the link of your original thread in order I can check something …

thanks Marc
here is the link
https://www.excelforum.com/excel-pro...ml#post5782098

According to your new rules my VBA demonstration revisited for starters :

Please Login or Register  to view this content.

► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄

thanks very much for your assistance

Thanks for the rep' !

My demonstration works whatever if the result workbook is already opened or not if located in the same folder than the source workbook …