Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi Guys,
I want to Link with two sheet but in one sheet data is in row. Those data Paste with Paste Special --- Paste Link in second sheet in column. Please see below example. Sheet 1 (Entered Data) Sheet 2 (I want to paste in sheet) A B C D E A B C D E 1 Patel Upen Jr.Cl. 50 60 70 1 50 2 60 3 70 I have data as per sheet-1 & I want to do as per sheet-2 with using any function. Note : Please do not tips manually. I want to tips as on function. Thanks in Advance Upen Patel Mehsana (North Gujarat) India. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Upan
--In sheet2 A1; try the below formula which picks data from Sheet2C1 --Once you copy this to cell A1..copy down as required and copy across.. =OFFSET(Sheet1!$A$1,COLUMN()-1,ROW()+1,1,1) If this post helps click Yes --------------- Jacob Skaria "Upen Patel" wrote: Hi Guys, I want to Link with two sheet but in one sheet data is in row. Those data Paste with Paste Special --- Paste Link in second sheet in column. Please see below example. Sheet 1 (Entered Data) Sheet 2 (I want to paste in sheet) A B C D E A B C D E 1 Patel Upen Jr.Cl. 50 60 70 1 50 2 60 3 70 I have data as per sheet-1 & I want to do as per sheet-2 with using any function. Note : Please do not tips manually. I want to tips as on function. Thanks in Advance Upen Patel Mehsana (North Gujarat) India. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I link cells, sheet to sheet, to recognize row deletions? | Excel Discussion (Misc queries) | |||
link formulas sheet 1 to same cells for sheet 1,2,3 etc | Excel Worksheet Functions | |||
???Replicate a sheet but chart still link to original sheet | Charts and Charting in Excel | |||
Excel how do I link text values in one sheet to another sheet? | Excel Discussion (Misc queries) | |||
trying link row on one sheet into column on another sheet | Excel Worksheet Functions |