Formula Pasting

[SeaStar]

Hi,
what i mean is, and im finding it difficult to explain, that i have formulas like
10%
15%
etc....
and i would like a formula in a new sheet to pull these formulas but in a row not a column, so rather than copying and pasting each week, just drag a formula along a row in my new sheet that will pick up a formula in a column in another sheet?

 

[GorD]

Not sure what you mean by graphthese formulas, but you can quickly change the layout using edit copy, edit paste special and selecting transpose.

hope that is of some help