| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Autofill from column to row
I have a worksheet with data in a column and want the data on another sheet
in a row, sorted in another way. I tried to use autofill to get data from every 25th cell in the column to the row on the other sheet, ['sheet 1'!F2"] in cell B2, ['sheet 1'!F27] in cell C2, ['sheet 1'!F52] in cell D2 and so on. Excel autofill wont understand what I want, is there any other way of solving this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort by row instead of by column? | Excel Worksheet Functions | |||
| Format cell in column B based on value in the next cell (column c) | Excel Discussion (Misc queries) | |||
| Formula for a column | Excel Discussion (Misc queries) | |||
| Copying the contents of a column into a chart | Excel Worksheet Functions | |||
| How to calculate the data in excel 2002 including only the last 9. | Excel Worksheet Functions | |||
Threaded Mode
