Rollup sheet

[krodriguez]

Hello, does anyone know how to create a rollup sheet that adds all values from other sheets in the same work book? all sheets will have same formats, rows, titles, everything will be identical except for the data in the cells, which needs to rollup to the main sheet (I'm trying to avoid go 1 by 1 sheet and added manually).

Thanks

 

[Joe4]

It all depends on how you define "rollup".

If you are just adding the same cells across the worksheets, it is pretty easy.
See: http://www.notjustnumbers.co.uk/2014/05/excel-tip-adding-same-cell-across.html

If it making a continuous list, where you copy all rows, and paste after the last row, and repeat the test for the other sheets, that probably involves having to use VBA.