I have a list of 28 names in column A
I want numbers in column B to run from between 70 and 97
I have a name part way down the list at B15 that I need to be able to input the number into, and each cell below that number to be B15+1 up to a maximum value of 97 then the next cell to be 70.
I'd like this to happen each time I change the number in cell B15
Using excel 2016 if that makes a difference.
Bookmarks