Good Afternoon,
I've been working on a file that has been automated in the past with simple formulas or just by linking cells to other sheets.
In this case, I'm having trouble programming a macro, by using a button, to copy a specific table in between ranges.
The ideia is to click the button that will insert the table under the others of the same kind, but above another 2 tables that must be in that order.
The point being that it copy the table below the one created before.
I also need help automatically naming sheets when created. I need to click a button, which will copy an example sheet, but it needs to follow a specific pattern, name-wise.
I've tried the regular programming on vba, but i've been tweaking it, with no success so far.
I'm attaching the example document.
Thank you for your help.
I've been working on a file that has been automated in the past with simple formulas or just by linking cells to other sheets.
In this case, I'm having trouble programming a macro, by using a button, to copy a specific table in between ranges.
The ideia is to click the button that will insert the table under the others of the same kind, but above another 2 tables that must be in that order.
The point being that it copy the table below the one created before.
I also need help automatically naming sheets when created. I need to click a button, which will copy an example sheet, but it needs to follow a specific pattern, name-wise.
I've tried the regular programming on vba, but i've been tweaking it, with no success so far.
I'm attaching the example document.
Thank you for your help.
