View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ghost ghost is offline
external usenet poster
 
Posts: 41
Default How to transfer specific range to another range ?

Greeting,

I have a range that starts for example from cell A1 to A10 in €śSheet1€ť and I
have five ranges in €śsheet2€ť. What I want to do is transferring For example
A1:A2 from sheet1 to the first range in sheet2 which starts from B1:B2 and
range A3:A4 to Range I4:I5 in sheet2. How to make that in one go?