copy formulas to different cells in another worksheet

J

jskamm

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
 
W

Wildcard

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
Macro to copy cells from one worksheet to another 1
Concatenate problem 7
Copying data and formulas from one workbook to another 0
Format linked workbook cells (updated) 2
How do I copy an absolute column and relative row to the right? 1
copy to different worksheet 6

Top