Transpose Formula onto New Sheet

K

Kim

Okay here is my problem..

In Sheet 1, I have numbers which are summed in Row 10. So in Row A10, C10, E10, G10, I10, K10, M10 there is a Sum Formula
Column A C E G I K
Row 10: 12 90 56 45 65 77 8

I want to Copy and Transpose this information from Sheet 1 into Sheet 2 but into Column I10, I11, I12, I13, I14, I15, I16
But I need for the formula to copy too b/c if there is a change to Sheet 1 - Sheet 2 needs to update automatically

I hope that makes sense. Any help would be appreciated
 
F

Frank Kabel

Hi
enter the following in I10
=OFFSET('sheet1'!$A$10,0,(ROW()-10)*2)
and copy down

--
Regards
Frank Kabel
Frankfurt, Germany

Kim said:
Okay here is my problem...

In Sheet 1, I have numbers which are summed in Row 10. So in Row
A10, C10, E10, G10, I10, K10, M10 there is a Sum Formula.
Column A C E G I K M
Row 10: 12 90 56 45 65 77 82

I want to Copy and Transpose this information from Sheet 1 into Sheet
2 but into Column I10, I11, I12, I13, I14, I15, I16.
But I need for the formula to copy too b/c if there is a change to
Sheet 1 - Sheet 2 needs to update automatically.
 

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

Top