Macro to enter calculation in cells adjacent to cells with values?

Hi all -

I'm a rookie with macros and could really use some help.

This workbook is constantly exported from our accounting system. I currently have a macro under personal that the accountant can run to delete the unnecessary columns, but I would like to add another automation -

I need to divide each cell in column G by the cell in column E in that same row, then put the answer in column H of that same row. The first entry will always start in row 5, but the last entry is always unknown.

Any help would be great! Thanks!

Something like:

Dim LR as Long

LR = Range("G" & Rows.Count).End(xlUp).Row

With Range("H2:H" & LR)
    .FormulaR1C1 = "=RC7/RC5"
    .Value = .Value
End With

Try this

    Range(Range("H5"), Range("G65536").End(xlUp).Offset(0, 1)) = "=IF(ISERROR(RC[-1]/RC[-3]),"""",RC[-1]/RC[-3])"

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.