Jan 20 2021 09:29 PM
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
Jan 20 2021 09:52 PM
@alexoliverrMaybe if you make the table into a std page, firstly, and then copy or insert the new page 30 times...
Jan 21 2021 06:43 AM
You may select all sheets
and in A1 enter the formula like
=TRANSPOSE(INDEX(Sheet1!$C$4:$F$103,SHEET(),0))