excel data in list N1, N7, N13 etc want to transfer to A1, A2, A3
 

I have a list which contains data in N1, N7, N13 and so on.
I wish to automatically transfer this list (when new list is opened), to
simple A1, A2, A3 and so on. I cannot find a function which allows this. When
I try 'writing' the first few rows ie '=mysheet!(N1) ~ (N7)' etc and dragging
down the list resets immediately after my last input.
Please help if this makes any sense to you?

Thank you.

excel data in list N1, N7, N13 etc want to transfer to A1, A2, A3
 

Put this formula in A1:

=INDIRECT("N"&(ROW(A1)*6-5))

and copy down as required.

Hope this helps.

Pete


On Jul 2, 4:51*pm, Weejock71
wrote:
I have a list which contains data in N1, N7, N13 and so on.
I wish to automatically transfer this list (when new list is opened), to
simple A1, A2, A3 and so on. I cannot find a function which allows this. When
I try 'writing' the first few rows ie '=mysheet!(N1) ~ (N7)' etc and dragging
down the list resets immediately after my last input.
Please help if this makes any sense to you?

Thank you.