Copy formula for ranges from diff sheets

B

Bernie

Unfortunatley then i have to go to every sheet, copy and paste special
(transpose)

What I need is some sort of formula that will copy the same range fro
_all_sheets_ and then paste special (transpose) on to the referenc
sheet.

?
 
I

icestationzbra

when it is pasted on the reference sheet, is it all pasted in the sam
row, or each sheet's data is pasted on the next row
 
Top