Sorry, I don't know of any "easy" way to do what you ask. You'll probably have to hand enter each reference. (copy a basic formula and edit the cell reference)

Bruce