VBA loop each cell with two tables.

[Marvelous]

Hello Experts,

I am using two tables to keep track of changing data. The original data is in Table2. Table1 get's it's data from table2 by simple reference (each cell references it's counterpart (same position) in table2 i.e.: Cell F6 has formula "= AO6", Cell G7 has "= AP7"etc..). Both tables are the same size. Table1 is in cells G6:W42 and table2 is cells AO6:BF42. These are just ranges (not Excel tables) but could be converted if necessary. Basically I am trying to make it where the user may change a cell in Table1 or hit delete to revert back to the original data from table2. I have vba code to do this one cell at a time (see below) but my table is large. Is there any way to code this with a Loop where I don't have to write this code for each individual cell? Also, how do I handle this if someone adds a row to the tables. I tried to search for this but the only thing I could find was how to use an if statement to put a static value in a table. I'm a vba novice and struggling to figure out how to reference rows and columns in two different tables.

'If Range("F6").Value = "" Then
    'Range("F6").Formula = "=AO6"
    'End If
'End Sub

Thanks for your help!
MLS