layout Cell reference column

**tek9step** · 07-08-2009, 05:02 AM

Hi

I am not sure how this is possible without doing copy pate transpose or individually refereing each cell to source. I would like the heading to be presented as in sheet1 which is sourced from Source sheet but if anychanges are made to source it updates the Sheet1. I have attached an example to illustrate. (Headers are not fixed number)

Thanks

Regards

Tek9step

**rwgrietveld** · 07-08-2009, 05:12 AM

Put this in Sheet1!A4 =INDEX(Source!$C$4:$H$8,COLUMN(),ROW()-3)
Copy right, down to Sheet1!E9

**tek9step** · 07-08-2009, 05:26 AM

Thanks Ave Ricardo it worked. Just for understanding could please give an explanation how the function is working it would be helpfull. Thanks again

Regards

Tek9step

**rwgrietveld** · 07-09-2009, 07:20 AM

This is quit straith forward:

=INDEX(Source!$C$4:$H$8,COLUMN(),ROW()-3)

The function normally equals. Index (Range, Row, Column)

By swapping the column and row you'll get the transposed result