copy a formula within a row from a column on another worksheet

J

JC

I am attempting to copy text from a column to a row in another worksheet via
a formula. For example A1, A2, A3, A4...from worksheet 1 will be copied to
B2, C2, D2, E2...on worksheet 2. I can simply do this with cut and paste
special using the transpose function but I want to pull changes from
worksheet 1 into worksheet 2 automatically using a formula. I used
=T('Worksheet1'!A1) but cannot copy across the row.
 
T

T. Valko

Try this:

=INDEX(Sheet1!$A1:$A4,COLUMNS($A:A))

Copy across as needed. Adjust range to suit.

Biff
 
D

driller

the transpose function allows to pull changes made from sheet1 range to sheet2
range
On sheet2 : select cells from B2 to E2 : type in formula bar
=Transpose(sheet1!A1:A4)

hit Ctrl-Shift-Enter
{} brackets will be inserted by excel automatically.
B2:E2 must SHOW the values same with sheet1!A1:A4
now go to sheet1, cell A2 and try to change the cell value or content...you
can see that Cell B2 pull the change automatically....

Note if the source range has a blank cell, the corresponding transpose
result cell will show a 0. <to bear with it>
 
G

Gord Dibben

JC

In Sheet2 B2 enter this formula.

=OFFSET(Sheet1!$A$1,COLUMN(A1)-1,)

Copy across to wherever.


Gord Dibben MS Excel MVP
 

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