I have a workbook with a series of tables, each of which contains an allocated index number for each GPS mark therein. I can foresee that over time as new marks are entered in the workbook, I will need a method to maintain the next available number to use from a set range. Rather than visually scan up and down the column A data, I've created an index table to try and simplify to task, and this table contains not just numbers but coloured interiors to signify which GPS marks have an allocated Index number and are either allocated to a Lowrance plotter, or Simrad plotter or not uploaded onto either plotter. I am hoping to count cells by interior colour. From another thread I've been advised to manually force a recount, which I think I shall do by way of a button. Am i on the right track here?