Automatically copy row header to column header...

[Soons]

A good afternoon all,

Defining the title of the thread was the first difficulty, describing the item will be the second...

I want to make a matrix, where the column headers and the row headers are the same. When I change the name of the row with current value "b", I want the column with value "b" to change as well. We are defining a matrix to combine products for our clients, and we will have to change the names of the products more then 1 time. As I do not want to make an error with changing the name in a row but forget to update the column, I want the values in column A (A1:n30) to be copied/changed automatically in row 2 (B1:n1)

Any thoughts about that ?

I tried to give B2 the value of A3 with "=A3" and C2 of A4 (="A4") but this is time consuming. Anybody a solution ?

Thanks

Peter

[royUK]

Can you attach an example workbook?

[Soons]

I attached a file and hope this makes things more clear.

So when I change "Value1" in field A3 I would like B2 to change automatically.
Same for A4 and C2, A5 and C3.

Thanks,

Peter

[royUK]

Just create a template sheet with the formulas in.

In B2 use =A3

When you have set the sheet up, just create a copy whenever you need to

[mhuston]

or use copy|paste special and select Paste Link.