I have a table in Excel, used as an Issues Log, and would like to have the Ref No Column generate a new number(1,2,3,4,etc.) each time a new record is created by tabbing through the fields.
I'm not sure if VBA is the solution, or if a formula could do it.....I'm just not sure where to begin.
Any help would be greatly appreciated!
Thanks
Bookmarks