Forum Discussion
How to Automate Data Submission Table w/ VBA
I'm eager to automate a data submission screen by creating formulas to transform and load data into a separate tab in a format that is digestible by one of our upstream reporting systems. In short, ...
I'm not sure but it looks like you just need either a pivot table, or formulas to mimic a pivot table (which many simply be PIVOTBY().
Something like:
=PIVOTBY( [Account], EOMONTH( [Date], 0), [Amount], SUM, 0, 0,, 0,, ([Cost Center] = A2)*([Profit Center] = A1) * ([Date] >= DATE(2024, 7, 1) ) )
Thanks, I'll check it out. I was hopefully for a more user friendly option that included a macro button users could click but simplicity is best if it works.