Creating reports from bulk data

Occasional Visitor

Hi all,

I am wondering if it is possible to do the following,

I have been given the following data to create reports with,

 

23  28   43   54

29  43   24   12

98  22   44   43

12  65   21   03

 

There will be around 30 lines of the four numbers, and I would like to be able to copy each line to the same four cells, across 30 sheets.

I.e

Sheet 1, A1 =23, A2 = 28, A3 = 43, A4 = 54

Sheet 2, A1= 29, A2 = 43, A3 = 24, A4 = 12

etc

 

Is there a formula or tool I am missing to achieve this as manually copy pasting isn't an option for the pure amount of data it has to process.

 

Thank you

2 Replies

@alexoliverrMaybe if you make the table into a std page, firstly, and then copy or insert the new page 30 times...

@alexoliverr 

You may select all sheets

image.png

and in A1 enter the formula like

=TRANSPOSE(INDEX(Sheet1!$C$4:$F$103,SHEET(),0))