Hi
What is the best way to do the following with VBA:
I have this table:
And I need to transform it to:![]()
Company jan feb mar ... Com1 11 12 13 Com2 21 22 23 ...
Note. I have a lot of companies, and this macro has to be run a log of times, so speed is an issue.![]()
Company Month Sum Com1 Jan 11 Com1 Feb 12 Com1 Mar 13 Com2 Jan 21 Com2 Feb 22 Com2 Mar 23
Bookmarks