View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andrea Andrea is offline
external usenet poster
 
Posts: 112
Default Macro to find and move column

Hi
I am wanting to run a macro that
1) finds specific text eg "XYZ"
2) select this entire column and cut
3) paste after the last column

I am using the find function as the column that XYZ appears in will vary in
different spreadsheets. There may be a better way?!

Thanks
Andrea