Automatically duplicating row titles as column titles

[eggplant_casserole]

I want to create a chart that would have titles for each row, say in the A column, and the same data as titles for each column, say in the 1 row.
So B1=A2, C1=A3, D1=A4 etc.

I need to be able to do this automatically, so if I add an item in column A, it would add itself as the title of the last column, too.

I'll also be using an automatic sort script. I've tested this by manually naming the column titles, then entering an item somewhere between the current data alphabetically and it sorted the colums, too - so this shouldn't be a problem.

How can I go about doing this?

Thanks in advance for any assistance - it is greatly appreciated!

 

[eggplant_casserole]

I still haven't come up with anything for this - any thoughts?

In case I'm not explaining myself well, here's a screenshot:

As you can see, I can manually put in code (e.g. =A4 in D1), but I want this to auto-generate when I put another value in the A column.

I am using Excel 2003.

 

[John Davis]

I still haven't come up with anything for this - any thoughts?

In case I'm not explaining myself well, here's a screenshot:

As you can see, I can manually put in code (e.g. =A4 in D1), but I want this to auto-generate when I put another value in the A column.

I am using Excel 2003.

You could do this with a helper row. For instance if your helper row was 100

in B100 enter 0 in C100 enter = B100+1 then copy accross as far as you think necessary

Then in b1 enter this formula =IF(OFFSET($A2,B100,0)="","",OFFSET($A2,B100,0)) and copy accross.

 

[Smitty]

Welcome to the Board!

You can use INDIRECT:

=INDIRECT("A"&COLUMN())

HTH,