well i don't want to have to keep entering the formula in each cell, i envisaged something along the lines of using the cells in a column which would detect if an entry was made in a column it would automatically generate the adjacent column values as the data differs from different sources depending where it is from