Please see Excel spreadsheet below:
I'm trying to create a code to find and delete all the cells that contain the text"Student:", and shift the cells left. This text can appear more or less depending on how many students logged in inside vs. outside the school.
Thanks,
knaimi
Last | First | |
Smith | John | |
Smith | John | |
Smith | John | |
Smith | John | |
Student: | Smith | John |
Smith | John | |
Smith | John | |
Smith | John | |
Smith | John | |
Smith | John | |
Smith | John | |
Student: | Smith | John |
Smith | John | |
Smith | John | |
Student: | Smith | John |
Smith | John | |
Smith | John | |
Student: | Smith | John |
Smith | John | |
Smith | John |
I'm trying to create a code to find and delete all the cells that contain the text"Student:", and shift the cells left. This text can appear more or less depending on how many students logged in inside vs. outside the school.
Thanks,
knaimi