That won't work in this case lads.

Dojj, you need the formula in each cell, so copy and paste it. Excel will update the cells the formula points to itself.

Start with just one cell first though so you know you've got the formula right.

You can do this between workbooks but it's a little more complicated. If you need to do this I can show you how though.