Forum Discussion
Which formula to use to get data from 11 sheets to trial balance
Hi, My question is how to effectively get the numbers from planning sheets (there is 11 of them, each one represents one colleague to plan) into trial balance? From trial balance to P&L I already ha...
An alternative could be Power Query and a Pivot Table. In the attached file you can add data to the blue dynamic tables in the first 7 sheets. In sheet 8 is a green result table that combines all the data from the first 7 sheets. You can right-click in any cell of the green table to update the data collection from the first 7 sheets. Then you can click in any cell of the Pivot Table in sheet 8 and right-click to update the results of the Pivot Table.