Hi,
I'm working with a group that would prefer we use excel tables for one of our reports. So far it worked well in 2023 as our columns were 2023-2027. Now I need to change the start column to be 2023 or 2024 based on the project and others to follow. Normally this would be simple with setting formulas, but as soon as I set an excel table header to be based on a formula excel defaults the value to "0".
I'm sure I could work something out with VBA, but otherwise is there a simple way to have table names change based on a formula?
Bookmarks