View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Craig Craig is offline
external usenet poster
 
Posts: 208
Default How to copy large block of cells but paste into one column

Hi

How can I take a large block of data (A1:Y300 which is 24 cols, 300 rows or
7200 cells of data) and paste that data into another sheet but only into one
column (so I get the 7200 data cells all in one column from say B1:B7200.

thank you!!

Craig