View Single Post
  #1   Report Post  
Dennis Harrelson
 
Posts: n/a
Default Can I copy a row to a column?

Hello, Folks
I need to have a column of values on one sheet equal a row of values on a
different sheet. i.e.: 'sheet2'A1='sheet1'A1; 'sheet2'A2='sheet1'B1;
'sheet2'A3='sheet1'C1; etc. Is there a way to do this using edit/fill or
copy? It's way too tedious to type every cell in, or even to click from one
sheet to the other for every cell, but I can't find any short cut.
TIA,
Dennis