by macarony » Sun Sep 20, 2020 9:49 pm
If I have a list of names starting at A1 and then goes down the list next cell A2, lets say there are 8 names with John smith in A1 how can I write a formula that every time I run the routine it drops John smith down one place until his name reaches the end of the range of names, the next time I run the routine he goes back to A1 and the process repeats?
thanks