|Good aft all,|
I'm not a good user of VBA but I have a task to deliver on monday.
What I need is a macro that will look at the value in C24 (say C24=12), and based on that value, insert a number of rows (say 12 rows) below C8 in sheet2 of the same workbook, and fill in the newly inserted 12 rows with data.
- (A1=11 800)
- each of the 12 rows represents one staff and each staff cannot handle more than 1000 units,
I want to put in C9, C10, ...C20 of sheet 2, the values 1 000, 1 000, 1000 ....... 800 so that the total sum up to 11 800, ...
... and in B9, B10, ...B20 of sheet 2 the Staffs: Staff1, Staff2, ...Staff12