Thats great, thanks carim, but I can't then copy across all the rows and down all the columns as it keeps the D11 value constant... Is there anyway I can do it so going down its =F11-D11, =F12-D12 and then across =F11-D11, =G11-D11 aswell so I dont have to keep typing a formula in? Does that make sense?
Bookmarks