Incremental Rows

Hi,

I have what seems quite a simple problem.

In Cell C7 of my sheet I have this formula returning a value from a PIVOT table in another sheet: =UPPER('UNI Pivot'!A6)

As I drag this across the columns (to form headings) I would like the rows to increase in the formula so it looks like:

=UPPER('UNI Pivot'!A6)
=UPPER('UNI Pivot'!A7)
=UPPER('UNI Pivot'!A8)
=UPPER('UNI Pivot'!A9)

And so on...

However, at the moment when I do it it simply increases the Column so I get: B6, C6, D6.

Is there something I can add to this formula to do this?

Thanks for help in advance.