Hello...My name is Robert, and I am requesting assistance to create a macro that will allow me to copy 5 non contiguous equally-sized ranges from Column A, Column B, Column C, Column D and Column E along with pasting them to Column F, Column G, Column H, Column I and Column J in one large cluster. Furthermore, I would like the data to be automatically alphabetized by student name.
What you are seeing in the attached image is an example of my actual 5 classes of students. I selected and copied each section of the data on the left side, and pasted it on the right side, I also manually sorted the target data in alphabetical order, but I am trying to reduce as many manual steps as possible during this process. Each class has blank cells towards the bottom of its list to accommodate new students. I simply don't want the blank cells mixed-in with the non blank cells after the target data is made. The ranges for my actual classes are as follows:
Class 1(A1:E40)
Class 2(A41:E80)
Class 3(A81:E120)
Class 4(A121:E160)
Class 5(A161:E200)
What you are seeing in the attached image is an example of my actual 5 classes of students. I selected and copied each section of the data on the left side, and pasted it on the right side, I also manually sorted the target data in alphabetical order, but I am trying to reduce as many manual steps as possible during this process. Each class has blank cells towards the bottom of its list to accommodate new students. I simply don't want the blank cells mixed-in with the non blank cells after the target data is made. The ranges for my actual classes are as follows:
Class 1(A1:E40)
Class 2(A41:E80)
Class 3(A81:E120)
Class 4(A121:E160)
Class 5(A161:E200)