Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is transfer data from one Excel file to another possible? | Excel Discussion (Misc queries) | |||
Transfer Excel data into Word, including text box data | Excel Discussion (Misc queries) | |||
transfer data from one excel sheet to another | New Users to Excel | |||
TRansfer of data from excel | Excel Discussion (Misc queries) | |||
transfer data in excel between sheets | Excel Discussion (Misc queries) |