I actually solved this. I did it by writing the code for one column; column C, and then just manipulated the code I had written for column C with Find/Replace, for each other column.

Column C, cell 6 has a default value of 10.

The code for that cell is:

Range("C6").Value = 10


Continued for more context:

Range ("C7").Value = 5
Range ("C8").Value = 3
Range ("C11"). Value 10

All the way down to the end of that data in column C.


Same for column G, H, I ect....



G6, F6, etc...


Thank you all for your help!

Will