Posts1Registration dateMonday August 13, 2012StatusMemberLast seenAugust 13, 2012
Aug 13, 2012 at 09:15 PM
Posts365Registration dateMonday February 7, 2011StatusContributorLast seenSeptember 30, 2013
Aug 16, 2012 at 01:22 AM
I am building a University Timetable. Each subject we offer occupies one row on an excel spreadsheet, we have about 200 subjects in total. Each row inlcudes a value in column M, which is how many tutorials should be scheduled. This value can be anywhere from 1 to 20, or could be blank if the subject has no tutorials.
I would like an excel macro which inserts n number of rows under each row, where n is the value in column M.
Ideally it would cycle through each subject inserting n rows based on column M, all the way to the bottom.