copy formulas to different cells in another worksheet

G

Guest

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
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#Value Error 6
I need to copy a formula to a 100 cells 3
How do I copy an absolute column and relative row to the right? 1
copy to different worksheet 6
Copying template from one worksheet to another 2
Macro to copy cells from one worksheet to another 1
Concatenate problem 7
Excel Copy cells from one worksheet to another workseet - increment row & do again 0

Top