Hello,

I fear the answer to this may be easy, but I have yet to find a solution that works so I am hoping someone can help me out. I have a workbook that contains 4 worksheets that each have identical column headings. I also have a userform that inputs data into each of these worksheets depending on which category is selected on the userform. Where there is a difference is in their numbering structure. Sheet 1 is 1,2,3,4,5,etc. Sheet 2 is A1,A2,A3,etc. Sheet 3 is N1,N2,N3,etc and so on. What I would like to do is have the enteries auto number as the data is entered into them via the userform. The data from the userform is entered into columns B-K and the number of the entry is in column A. Currently I am using the dragdown feature to autonumber them once they are entered on the form. Any help here would be much appreciated.

Thanks