Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2
hi there i am really in a delima here i want to copy cell C1:C10 (which is a
formula and displayed vertically) into SHEET 2 in a horizontal format, so at the end if i make any changes in sheet 1(vertical) it should be displayed automatically in sheet 2 (horizontal) can anyone please help me ? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2
Hi!
Try this: =INDEX(Sheet1!$C1:$C10,COLUMNS($A:A)) Copy across to 10 cells. Biff "parag" <u23036@uwe wrote in message news:61c85a62d213d@uwe... hi there i am really in a delima here i want to copy cell C1:C10 (which is a formula and displayed vertically) into SHEET 2 in a horizontal format, so at the end if i make any changes in sheet 1(vertical) it should be displayed automatically in sheet 2 (horizontal) can anyone please help me ? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2
thanks biff this helped alot and it works like a charm
Biff wrote: Hi! Try this: =INDEX(Sheet1!$C1:$C10,COLUMNS($A:A)) Copy across to 10 cells. Biff Hi there i am really in a delima here i want to copy cell C1:C10 (which is a formula and displayed vertically) into SHEET 2 in a horizontal format, so at the end if i make any changes in sheet 1(vertical) it should be displayed automatically in sheet 2 (horizontal) can anyone please help me ? -- parag Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200606/1 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2
You're welcome. Thanks for the feedback!
Biff "parag via OfficeKB.com" <u23036@uwe wrote in message news:61d353e4a833c@uwe... thanks biff this helped alot and it works like a charm Biff wrote: Hi! Try this: =INDEX(Sheet1!$C1:$C10,COLUMNS($A:A)) Copy across to 10 cells. Biff Hi there i am really in a delima here i want to copy cell C1:C10 (which is a formula and displayed vertically) into SHEET 2 in a horizontal format, so at the end if i make any changes in sheet 1(vertical) it should be displayed automatically in sheet 2 (horizontal) can anyone please help me ? -- parag Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200606/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Automatic cell increment with data from sheet 1 to sheet 2 | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |