Formula Pasting

SeaStar

New Member
Joined
Sep 15, 2006
Messages
14
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?
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

GorD

Well-known Member
Joined
Jan 17, 2004
Messages
1,446
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
 

Watch MrExcel Video

Forum statistics

Threads
1,113,812
Messages
5,544,458
Members
410,613
Latest member
Texman
Top