Hi,

I want to be able to enter a formula that will reference a cell based on the cell reference of another cell, i.e. every 7th cell contains the value I require, i want to show these in consecutive cells in a seperate table without directly referencing each of the cell individually, so the result will be

b20 = b2
c20 = I2
d20 = P2
e20 = w2

and so on and so forth......

Thanks,

Martin