Could u pls arrange the List of Student numbers (lets take 500 student hall tickets), and arrange these 500 nos into 6 rows and 4 coloumns by using macros
for clarification just see in to attached sheet below
Could u pls arrange the List of Student numbers (lets take 500 student hall tickets), and arrange these 500 nos into 6 rows and 4 coloumns by using macros
for clarification just see in to attached sheet below
1 way
Kind regardsSub test() lr = Range("A" & Rows.Count).End(xlUp).Row j = 1 For x = 1 To lr For i = 5 To 8 Cells(j, i).Resize(6) = Range("A" & x, "A" & x + 5).Value x = x + 6 Next j = j + 7 Next End Sub
Leo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks