I kinda think the title says it all but i'll describe a bit...

I have some very simple code that enters =today() into H5, and the VBA equivalent to = H5-F5 into I5. This should always start from these two cells because row 4 has all the column headers. From here I need it to paste the values of the 2 formulas (petty sure i can figure that out) and then do the same thing on each row until it reaches the last row of column G (which is never blank). I can see based on other posts how a loop function operates and the typical last row function but I haven't the slightest on how to get them to work in tandem. My VBA is in its infancy at best. Thanks to all who offer suggestions/solutions.