oeldere - thank you for the compliment! I appreciate it, I agree that it's not the ideal solution, that was also what I wrote when I uploaded the file, and said it was a little primitive, as I gave an IF formula for each 12 scenarios (1 for each month). That's the only way I found to accomplish that without having a PIVOTABLE in action.
since I'm familiar with the trial balance report - I assume that the structure of the report is quite solid, columns will always remain Jan-Dec, and lines are not expected to change massively, only the values are varying each period - so I guess no great changes are needed to be done.
Thanks again, great honor hearing that from an expert user![]()
Bookmarks