heh heh\


yes the data is most definatly dummy data, something people at work have been whipping up for a while for just these kind of tests....

you were correct, using the absolute references it has stopped the formulas altering themselves as data is cut and pasted, but am still finding every now and then when i go down to check a cell will have gone to something like

=if(#ref-#ref) it seems to forget the cells it is meant to link to