View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
parag
 
Posts: n/a
Default 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 ?