Hi,
I am having quite a time figuring how to make this work..
I have a Sheet with a very big table data base with several columns. The table is basically a budget calculator for my engineering projects. I ve created some buttons with recored macro for easier (one click) filtering. All works fine till I duplicate the sheet for the next project I want to budget.
I understand that the problem is that all my macros reference the name of the table with list.object and when a the sheet is duplicated the name of the table is automatically updated.
Is there a way to created a button that duplicates my sheet and automatically update the new table name across all my macros ?
If not, what is the best way to resolve this problem ?
I am quite new to this and I am sure there is a easy way to do it.
I am having quite a time figuring how to make this work..
I have a Sheet with a very big table data base with several columns. The table is basically a budget calculator for my engineering projects. I ve created some buttons with recored macro for easier (one click) filtering. All works fine till I duplicate the sheet for the next project I want to budget.
I understand that the problem is that all my macros reference the name of the table with list.object and when a the sheet is duplicated the name of the table is automatically updated.
Is there a way to created a button that duplicates my sheet and automatically update the new table name across all my macros ?
If not, what is the best way to resolve this problem ?
I am quite new to this and I am sure there is a easy way to do it.
