Thread: List to grid
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Jim is offline
external usenet poster
 
Posts: 2
Default List to grid

Hi

Anyone know how to convert a list of number (A1:A78) to a 6 column grid so
the numbers go down 6 rows and down the next 6 rows etc until you reach the
end of the list/col?

I'd like to do it in VBA but I'm not clever enough!

Thanks

Jim