Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy a formula within a row from a column on another worksheet
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy a formula within a row from a column on another worksheet
Try this:
=INDEX(Sheet1!$A1:$A4,COLUMNS($A:A)) Copy across as needed. Adjust range to suit. Biff "JC" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy a formula within a row from a column on another worksheet
=INDEX(Sheet1!$A$1:$A$100,COLUMNS($A:A))
"JC" wrote: 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy a formula within a row from a column on another worksheet
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 -- ***** birds of the same feather flock together.. "JC" wrote: 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy a formula within a row from a column on another worksheet
JC
In Sheet2 B2 enter this formula. =OFFSET(Sheet1!$A$1,COLUMN(A1)-1,) Copy across to wherever. Gord Dibben MS Excel MVP On Tue, 30 Jan 2007 13:12:00 -0800, JC wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF in between rows | Excel Worksheet Functions | |||
Index and Match Formula | Excel Worksheet Functions | |||
Lookup function/sum function | Excel Discussion (Misc queries) | |||
Date formulas | Excel Discussion (Misc queries) | |||
Comparing a list to a Calendar worksheet. | Excel Worksheet Functions |