Thread: data swap
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
scott scott is offline
external usenet poster
 
Posts: 577
Default data swap

is it possible to swap cells without having to cut and paste? if i have data
in b3:b5 and c3:c5, and i want the data in each column to switch, is there a
function that allows me to do that?