Reflect column data in a row.

[sky]

Hi Guys,

I have data in a column (i.e. A1,A2,A3…….Ax) in sheet 1. This data needs to be displayed in sheet two in a row (i.e. C2,D2,D3…….Dx) in sheet2. Also I need the data to be dynamically updated if there are any changes in sheet 1.

Any suggestions other than using pivot tables?

Many Thanks

Robin

[Ron Coderre]

Try putting this forumula in Cell C2 of Sheet2 and copy it to the right:
=INDIRECT("sheet1!A"&COLUMNS($C:C))

Regards,
Ron

[sky]

Dear Don,

Thanks........ its amazing how easy things are when one knows how!! Your formula works a treat.

Thanks Once again

Robin

PS Do you know any good sites that offer basic tutorials on writing formulas??