| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy from another sheet but spreading the data out down the col
I need to rearrange some data from one worksheet into another.
For instance if A2 - A10 were numbers 2-10 I would like them copied into the second worksheet in A2,A5,A8 ( so A2=1, A5 =2, A8=3..) If B1-B10 were also numbers I would like them in A3,A6,A9. (from one worksheet to the other) So I would like to set up the first 3 rows with formulas linking back to worksheet 1 from 3 different colums and then use the filldown function with results occurring sequentially, at them moment it is missing values as I fill down,, hope someone can help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy data of two cells from Sheet 2 into one cell in Sheet 1 | Excel Worksheet Functions | |||
| Copy/filter data in a sheet from another sheet | Excel Discussion (Misc queries) | |||
| How can i copy data from a tabbed working sheet to a summary sheet | Excel Discussion (Misc queries) | |||
| how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 | Excel Worksheet Functions | |||
| Copy sheet 1 data to sheet 2 cells. | Excel Worksheet Functions | |||
Threaded Mode
