| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy data from sheet1 to sheet but in varying positons
I need to copy the info from Sheet1 a11 to Sheet2 a4, but then the next
entry is Sheet 1 a12 to Sheet2 a 24, Sheet 1 a13 to Sheet2 a44 etc.... with the spacing being the same number of cells apart. ='Sheet1'!$A12 goes into Sheet2 cell a24 ='Sheet1'!$A13 goes into Sheet2 cell a44 ='Sheet1'!$A14 goes into Sheet2 cell a64 I want to be able to paste the formula into Sheet 2 as there are 8 different items that I need to import per grouping. Any ideas? Bossman |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2!A1+ | Excel Discussion (Misc queries) | |||
| Copy result from sheet1 to sheet2 | Excel Discussion (Misc queries) | |||
| transfer data from sheet1 to sheet 2 | Excel Worksheet Functions | |||
| Macro-Copy various cells in sheet1 into next available row in sheet 2 | Excel Discussion (Misc queries) | |||
| Copy values from Sheet1 to Sheet2 | Excel Discussion (Misc queries) | |||
Threaded Mode
