| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
filling formulas
I want to take some values off one worksheet and put them in a table on
another worksheet. The issue is that the source numbers are in the same row but 7 columns apart. I want to put them into columns next to each other on another worksheet by filling the formula accross the columns. ie col 1 col 2 col 3 etc = 'sheet 1'!F4 ='sheet 1'!F11 ='sheet 1'!F18 Is this possible or do I have to manually change the cell references. I am using Excel 2002. Cheers |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
filling formulas
that should have been in the same column but 7 rows apart!!
"mattblack" wrote: I want to take some values off one worksheet and put them in a table on another worksheet. The issue is that the source numbers are in the same row but 7 columns apart. I want to put them into columns next to each other on another worksheet by filling the formula accross the columns. ie col 1 col 2 col 3 etc = 'sheet 1'!F4 ='sheet 1'!F11 ='sheet 1'!F18 Is this possible or do I have to manually change the cell references. I am using Excel 2002. Cheers |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
filling formulas
One way:
Column 1: =INDEX(Sheet1!$F:$F,(COLUMN()-1)*7+4) Copy across... In article , mattblack wrote: I want to take some values off one worksheet and put them in a table on another worksheet. The issue is that the source numbers are in the same row but 7 columns apart. I want to put them into columns next to each other on another worksheet by filling the formula accross the columns. ie col 1 col 2 col 3 etc = 'sheet 1'!F4 ='sheet 1'!F11 ='sheet 1'!F18 Is this possible or do I have to manually change the cell references. I am using Excel 2002. Cheers |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filling formulas | Excel Discussion (Misc queries) | |||
| Filling down formulas in a query table | Excel Discussion (Misc queries) | |||
| filling information from one cell and filling another. | Excel Worksheet Functions | |||
| Filling Formulas Across Workbooks | Excel Discussion (Misc queries) | |||
| Zero Filling | Excel Discussion (Misc queries) | |||
Linear Mode
