Is it possible to transpose a formula so I can make excel fill it in for me?
ie:
Worksheet 1
A B
Jan 10
Feb 20
Mar 30
Apr 40
May 50
Worksheet 2 ( I want)
Jan Feb Mar Apr May
=wk1!B1 =wk1!B2 =wk1!B3 =wk1!B4 =wk1!B5
I don't want to input each of these formulas manually... And if I do auto fill it gives me (Don't want this!)
Jan Feb Mar Apr May
=wk1!B1 =wk1!C1 =wk1!D1 =wk1!E1 =wk1!F1
ie:
Worksheet 1
A B
Jan 10
Feb 20
Mar 30
Apr 40
May 50
Worksheet 2 ( I want)
Jan Feb Mar Apr May
=wk1!B1 =wk1!B2 =wk1!B3 =wk1!B4 =wk1!B5
I don't want to input each of these formulas manually... And if I do auto fill it gives me (Don't want this!)
Jan Feb Mar Apr May
=wk1!B1 =wk1!C1 =wk1!D1 =wk1!E1 =wk1!F1