Pasting Formulas Transposed.

S

Sebastyan

New Member
Joined
Sep 3, 2006
Messages
4
Is there a way to copy a formula that is going horizontally and paste it on another sheet going vertical?

Kind of like pasting special values transpose only for formulas.

Thank you in advance for taking the time to look at this.
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
Sort by date Sort by votes
It works for Values transpose, but when I try to do the same thing with Formulas it gives me #REF! error.
 
Upvote 0
I have data on Sheet2 going across the page. This data is copied from a report we get from a website (no changing it). I made Sheet1 a sumary for the totals from Sheet2. On Sheet1 I want to make cell A1 = to A1 on Sheet2 (easy enough) then make A2 on Sheet1 = to B1 on Sheet2 and so on.
 
Upvote 0
I use the OFFSET function, or INDEX function to do this, fetching cells from different places dependant on what row my formula is on, like:
Code: 
=INDEX(Sheet2!$A$1:$Z$1,ROW()-1)
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question
Change formula from one sheet to the other without having to manually change it
Replies
1
Views
65
mickeystanford_alumni
M
C
  • Solved
Macro to refer to the current sheet
Replies
4
Views
146
MARK858
MARK858
E
  • Question
Excel VBA function that cuts a range and pastes it as transpose
Replies
4
Views
249
RoryA
RoryA
P
  • Question
HTML Table pastes on Column A!!
Replies
0
Views
113
panyagak
P
I
  • Question
Transposed data with blank spaces and create a Bar Chat without any space
Replies
1
Views
261
Eric W
Eric W

Forum statistics

Threads
1,203,677
Messages
6,056,688
Members
444,883
Latest member
garyarubin

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top