Replace Blanks with Formula with Relative References

[DaveWW00]

So have large spreadsheet with grid of elevations. Each column/row is 1 foot grid. There are blanks in it where there was no elevation data available. I need to interpolate those elevations using the surrounding known elevations. I can setup the interpolation just fine using a circular reference but what i am having trouble with is getting formula into all the cells. I need to replace blanks with formula that averages all four cells around it. This will result in circular references that will interpolate from known points nearby. So for example if cell D4 was blank formula needs to be =(D3+E4+D5+C4)/4. D5 would be =(D4+E5+D6+C5)/4. I have been playing around trying to make a macro or something to do this but am not having any luck. Can somebody please help me out with this? Basically need to find/replace all blanks with formula above but so the formula references the cells around it properly. Thanks!

 

[Jonmo1]

Try this

Do Not press ENTER on any of these steps until the end..

Highight the entire range
Press CTRL + G
Selct Goto - Special - Blanks OK
Type =(
Press Left Arrow
Press +
Press UP Arrow
Press +
Press Right Arrow
Press +
Press Down Arrow
Type )/4
Press CTRL + ENTER

 

[DaveWW00]

knew it had to be simpler than i was making it. thanks for your help. it worked perfectly.

 

[Jonmo1]

Glad to help, thanks for the feedback.