View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
pcor pcor is offline
external usenet poster
 
Posts: 148
Default Need a busy macro

I have data in Col A & B,\. The data starts at line one and CURRENTLY goes to
line 214..but that will increase over time.
In order to better display this data I would like a micro that would display
all the data in 5 blocks accros the screen.
So The first FIFTH of Cao A & B would remain where it is
The second FIFTH would be copied to COL D & E(leaving a col for seperation)
the third fifth would be copied to col G & H
and the same until all the data was listed in 5 BLOCKS(A & B D & E G & H
J & K M & N)
Any assistance would be appreciated
Thanks