List to grid
Not clear what "down 6 rows and down the next 6 rows" means.
Do you mean across 6 columns?
1,2,3,4,5,6
7,8,9,10,11,12
Or 6 columns with 1 - 13, 14 - 26 etc.?
Gord Dibben MS Excel MVP
On Fri, 9 Feb 2007 16:54:58 -0000, "Jim" wrote:
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
|