VBA Code to copy a cell with a number >0 to the next available column and skip blanks

[Krown]

I'm new to learning VBA and I'm trying to manipulate the data in my spreadsheet that I'm building. I want to track inventory usage raw data by copying the calculated result to the next available column excluding blank cells. How can this be done?

 

[Krown]

You are welcome!
Glad I was able to help.

You can see that I added lots of documentation in my code (the green lines) to try to explain what is happening at each step so you can follow along.

Yes! That is very helpful, especially to a newbie like myself. Thank you so much!