Should be simple

I have a number value contained in a cell. I want to write code that will take the number in the cell and combine it with a column to create a cell reference.

(i.e. cell aa7 contains the value 5. I want excel to paste information into lets say column ac. However, I want it to paste the information in the 5th row which it would get from cell aa7)

Make sense???

Thanks in advance