I purposely left it blank because even when I applied the code to a blank workbook it appeared to act in a manner that I didn't expect placing a bunch of zeros across many columns instead of just in 2 columns down many rows
I thought my example file might express my problem better
When I modified it I changed all your A column references to E and all the B Column references to G as per my files layout
I also changed the row 1 references to 2 as my data begins in row 2
But again even in a blank workbook I was a little puzzled by the outcome of running the script as it's written so I thought that perhaps I hadn't described my desired outcome clearly thus the example file
EDIT
Retried with a blank file with data set up in columns A and B and code works
My attempt to convert it must have been the issue, I did it in a rush before heading out to dinner and must have really messed it up
Thank you kindly for your expertise
Modified code is simply:
Bookmarks