This should be very simple, yet I cannot find the solution. I have a sheet that provides summary data from a main data sheet. For example, cell A7 returns the value (text) from cell 'Data'! A30, cell A8 returns the value (text) from cell 'Data'! A39, cell A9 returns the value (text) from cell 'Data'! A48, etc. What I need, therefore, is a way to make A39 become A48 without having to manually type it in. I want to have the cell ref as Axx+9, where xx is the previous used reference + 9 rows (i.e., A39+9=A48).