I have created a form in Excel which once completed they hit a button that has a macro that takes the information from the form and places it at the bottom of the previous data on another 'data' worksheet - that is working well.
What I would like to do in one of the cells in the fill in form is take the last number from column B in the 'data' worksheet and increase it by one and place it in the cell on the fill in form automatically. I have tried a macro and could get it to go to the end of the named ranged and right one cell then copy and paste special (ticking add) back on the form worksheet, but then the macro just remembers the last cell I used and doesn't reset to go back to the bottom of the database range once reset? I hope that makes sense - can anyone help?

thanks
Karen