SamT

This works perfectly for dropping the numbers down on the Input sheet. However it does not grab the new numbers from rows 54 up for the copy and paste. Maybe this will help to follow a flow chart so to speak

Start.jpg

Run Module 1

copy and paste new set of numbers from Drawn Numbers
Step 2 copy new set of numbers and paste to Input.jpg

step 3 new set of numbers in rows 49-101.jpg

Note how all numbers moved down from rows 49 to 101as new numbers "52" went to row 49

Run Module

Copy and paste new set of numbers


step 4 new set of numbers in rows 49-101.jpg

Rinse and Repeat