Excel VBA - How do I count off a no. of rows of data determined by a number in a

A

AdamW

Member
Joined
May 14, 2008
Messages
96
Reaction score
0
Points
6
specified cell? I have a large amount rows of data in a worksheet, which I am in the process of organizing and sorting into groups. Each row represents a student and I have a predetermined class size to fill. So, say I have 100 rows from (A1:H100) and I want to extract using VBA the number of students/rows specified by a number in a cell, example (J4=18); how would I write the code?

Thanks guys!
 
Back
Top