View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Bob is offline
external usenet poster
 
Posts: 972
Default Copying non-contiguous columns to contiguous columns

Forgive me, the Subject of my original post should have read: "Copying
non-contiguous columns on one sheet to different non-contiguous columns on
another sheet".


"Bob" wrote:

I need to copy data from columns J, M, and T (starting with row 7 and going
down each column until the first blank row is encountered, which can differ
from column to column) on sheet "Detail" to columns B, K, and R,
respectively, on sheet "Summary". I would greatly appreciate any help in
writing a macro that can do this.
Thanks in advance for any assistance.
Bob