copy formulas to different cells in another worksheet
 

Hi all,

I have summation formulas at e33, f33, g33, h33 and i33 on worksheet 1. I
need to copy this row vertically into worksheet 2 located at c10, c11, c12,
c13 and c14. I think I should be using the index function. Can anyone help?

Thanks

Use edit-paste special. It allows you to copy and paster the values,
formulas, formats...etc. You can also transpose and have them vertical
instead of horizontal. Much faster than indexing.

"jskamm" wrote:

Hi all,

I have summation formulas at e33, f33, g33, h33 and i33 on worksheet 1. I
need to copy this row vertically into worksheet 2 located at c10, c11, c12,
c13 and c14. I think I should be using the index function. Can anyone help?

Thanks