M
mattblack
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
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