Hi,
What I want is to be able to select a cell and the number in that cell
inserted into another cell on a different sheet in the same workbook and then
jump to that worksheet. I could use a commandbutton on the row that I want
the number from, but the trouble starts when I use autofilter to select a
selection of the data, the buttons remain where they are and therefore
reference the worng data cell.

All help apreciated.