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...
VSTACK() can stack data from 2D range from multiple sheets. VSTACK(Sheet1:Sheet11!A2:E5000) will stack data from sheet1 to Sheet11 range A2 to E5000. The you can apply other functions to perform operations like VLOOKUP() or SUM(). Here is an example to sum all values from these 11 sheet of ID situated in A3 cell.
=LET(x,VSTACK(Sheet1:Sheet11!A2:E5000),SUM(VLOOKUP(A3,x,5,0)))See the attached file for details.
I checked the file, it could only bring the data from sheet 1 to the trial balance sheet. The formula couldn't add data from other sheet. You may want to check the formula to see if there is anything missing