View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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.