Yes, I have no idea why I would need a Macro when it can be done with Tables, Named References or any other way. But thanks again Andy for the snippet, I am already modifying it to meet my exact needs :)
Completely agree with you on pivot and formula. I did the same but my supervisor wants it in macros for some reason and I am trying to piece together how to do it :(
Hello,
I have a sheet named "FinalOverview":
another sheet called "Data". The "Data" sheet has N columns and each column has specific numerical values. Ex:
The user enters values such as "2020" or "2021" in the Sheet "FinalOverview" and will click a btn to trigger macro. The macro then...
Hello,
I have a sheet named "FinalOverview":
another sheet called "Data". The "Data" sheet has N columns and each column has specific numerical values. Ex:
The user enters values such as "2020" or "2021" in the Sheet "FinalOverview" and will click a btn to trigger macro. The macro then...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.