Hello all. I am an Excel expert, but I've never had to do VBA coding in macro's, so I guess I'm not too much of an expert then!
The issue I have is I have a report that looks something like this:
Class Name
Instructor
Class Date
Class Name
Instructor
Class Date
And this repeats for 1500 rows. Basiclly I need a macro that will take the instructor and class date (which is always in the same location in reference to the class name) and class date and move them to the same row, then delete the 5 rows between the two class names, and repeat until there is no more data.
Does this make sense? Basically the report should look like this when done.
Class Name Instructor Class Date
Class Name Instructor Class Date
Any help would be greatly apprecitated!
The issue I have is I have a report that looks something like this:
Class Name
Instructor
Class Date
Class Name
Instructor
Class Date
And this repeats for 1500 rows. Basiclly I need a macro that will take the instructor and class date (which is always in the same location in reference to the class name) and class date and move them to the same row, then delete the 5 rows between the two class names, and repeat until there is no more data.
Does this make sense? Basically the report should look like this when done.
Class Name Instructor Class Date
Class Name Instructor Class Date
Any help would be greatly apprecitated!