In addition for the first problem, how could I include something in the macro so that he determines the size of the tables so that I do not have to specify the range of the tables, as the files modify every week, the header is the same but the number of rows differ. thanks