Need Relative Reference in VBA/Macro for Autofill

The VBA code below is my attempt at automating what should be a few simple steps in an inventory spreadsheet.
The step I am stuck at is how to autofill the 2 new columns based on the formulae copied from the columns on the right.
I need to figure out a way to reference the new columns without designated specific column labels because 2 new columns are added every week, both in this part of the spreadsheet and just after Column G (not shown). It would be nice to autofill both columns in one step, but ultimately as long as the autofill is accomplished, I don't really care what it takes.

I read through this thread: [SOLVED] Relative Reference and AutoFill- Macro. It was somewhat helpful, but I could not adapt it enough to what I need.

________________________________________________________

Please Login or Register  to view this content.

_______________________________________

Any and all help is greatly appreciated.

Please Login or Register  to view this content.

This is based on

Please Login or Register  to view this content.

Which can be written:

Please Login or Register  to view this content.

'Cells(Row, Column), So cells(1,1) = "A1", cells(1,2) = "B1"

The beauty of this method is that you can easily loop through a range of Cells.

Please Login or Register  to view this content.

I know, that is a stupid and slow example.

This would be faster:=

Please Login or Register  to view this content.

The copy function will copy your formulas so why go the autofill route?

If you want to fill down to the bottom of your data then replace the 20 with your last row.

So how do you find your last row?

Please Login or Register  to view this content.

This returns the row number of the last used cell in column34. ie Column AH

So:-

Please Login or Register  to view this content.

Or For your immediate need:-

Please Login or Register  to view this content.