I have the following:
cell G1 = A2
cell G2 = A4
cell G3 = A6

Is there a way to have this go all the way down the column. I know if the
cells equaled A2, A3, A4 I could just drag it down but it doesn't work in
this case. Any ideas? Thanks