Excel Macro, VBA help needed - Insert Cell based on value of a cell in another column

Hello all,

I would like to write a macro that will insert a cell in a column based on the data value of another cell in another column. My table has values in columns A-T, however, for these purposes, I only care about the values in column C and G.

If a value in Column C = "AA", "BB", or "CC", i would like a cell to be inserted into that row, in column G (shift the cells down). The table has varying number of rows from time to time, but columns dont change.

Before macro is run, the table looks like this...

A B C D E F G
1 A AA 1 A 1 A
2 B A 2 B 2 B
3 C B 3 C 3 C
4 D C 4 D 4 D
5 BB 5 C 5 E
6 E 6 6 F


Desired result for table, after macro is run....
A B C D E F G
1 A AA 1 A 1
2 B A 2 B 2 A
3 C B 3 C 3 B
4 D C 4 D 4 C
5 BB 5 5
6 E 6 6 D
E
F


I have attached a file displaying the example above.

Your help is greatly appreciated.

AW

Thanks, judgeh59! Your solution is exactly what I was looking for.

AW