Hello. How would I write code that loops through a specific column in a sheet until it finds the value 9 and then copy this value into the first row of a specific worksheet titled "name". I need to use a loop. Also, if you could provide resources where I can learn about the loop and other types of loops that would be great. Thanks!!