Paul,

If you look at the file you attached TS 4+ BB Game 3 (Macro Numbers Input)_phh2.xlsm.

The 2nd Macro takes the data from the "Counter Totals" sheet and paste them to Game3 sheet rows 50-100-150-200-250. Every time a new number sequences from the Input sheet it changes the data in the "Counter Totals" sheet and that data moves down a row in Game3


This is the same sheet I wanted to move where it paste the results so I can add more rows. In other words, right now I have the following from

Instead of the data going to50-100-150-200-250 I want it to go to 50-3000-6000-9000-12000

Example Data Distribution.jpg