Hello everyone,
So every month we export data and this data was always sorted a editited by hand.
I wanted to create a macro to automate it because it's always the same type of modification.
The problem is that we would have 1 tab per month in excel.
When I ran the original macro I created a table and just changed it's layout color.
The problem is that when I ran the same macro in an other tab, I have an error because the "table1" is now "table2".
Is there a way that the macro would not select the table name but the table in the active sheet instead ?
Thanks a lot !
So every month we export data and this data was always sorted a editited by hand.
I wanted to create a macro to automate it because it's always the same type of modification.
The problem is that we would have 1 tab per month in excel.
When I ran the original macro I created a table and just changed it's layout color.
The problem is that when I ran the same macro in an other tab, I have an error because the "table1" is now "table2".
Is there a way that the macro would not select the table name but the table in the active sheet instead ?
Thanks a lot !