copy multiple tables from sheet to two sheets based on lastrow value

[ABDELFATTA]

hello
I have many tables what I would if the table contains the last row in column g= 0 then copy to sheet "paid " and if doesn't contain 0 then copy to sheet "unpaid" with considering if the tables in sheets "sheet1" from any value in lastrow in column g to 0 then clear the tables from sheet "unpaid " and move to sheet "paid" I put the result into sheets paid & unpaid
note : if is possible do that by worksheet change event is better
thanks

[Bo_Ry]

Put this at Sheet1

Please Login or Register  to view this content.

[ABDELFATTA]

thanks but I no know how your code works as I far if change the value in column k then it supposes copy to sheets paid or unpaid , right or wrong? it doesn't happened any thing !

[ABDELFATTA]

sorry BO-RY your code is awesome , my bad I have to change in column k to see the changes
many thanks for the great code