Hi Everyone,

I am pretty new to VBA, I know somewhat what to do and I can follow the code I just struggle getting it right.

I have a spread sheet with multiple lines of information. Each line has a lot number and then a weight for that lot.

I have a column named shipped, so when we ship a weight is entered in that cell, I then want to paste another row under where the new weight will be calculated from the initial weight minus the shipped weight. There will also be a few more items. What I am wondering is if I can have a "template" row which I will copy and paste into the location I want. In this "Template" row I could have the formulas etc that will do the calculations etc.

TIA