I am pulling values from every 5th row of another worksheet. How can I
set that into the formula without doing it by hand? ie
row 5 ='Status!G30'
row 6 ='Status!G35'
row 7 = 'Status!G40'

is there a way that I can set the formula in row 6 to ='Status!G30+5
and the formula in row 7 to 'Status!G35+5

Glen