hello
I have 20 sheets named 1,2,3....20 and one sheet named "report"
In every sheet I have 20 rows of data.
I need to put all data from each of 20 sheets to report sheet
It means A1 to A20 from sheet 1 will go to A1 to A20 on report sheet.
A1 to A20 from sheet 2 will go to A21 to A40 on report sheet and so on.
It means B1 to B20 from sheet 1 will go to B1 to B20 on report sheet.
B1 to B20 from sheet 2 will go to B21 to B40 on report sheet and so on.
Which formula on report sheet A1 I need so when I drag the cell down I get on report sheet the data from A1 to A20 from al sheets?
Thank you
I have 20 sheets named 1,2,3....20 and one sheet named "report"
In every sheet I have 20 rows of data.
I need to put all data from each of 20 sheets to report sheet
It means A1 to A20 from sheet 1 will go to A1 to A20 on report sheet.
A1 to A20 from sheet 2 will go to A21 to A40 on report sheet and so on.
It means B1 to B20 from sheet 1 will go to B1 to B20 on report sheet.
B1 to B20 from sheet 2 will go to B21 to B40 on report sheet and so on.
Which formula on report sheet A1 I need so when I drag the cell down I get on report sheet the data from A1 to A20 from al sheets?
Thank you
Last edited: