No previous experience with macros, so any info would be helpful.
Suppose I have names in Column A, with 4 scores in B, C, D and E. I would like to copy and transpose those scores so that they will now be in G2 to G5. However, I would like to do this for 300+ people. How can I create a macro to do this? I've tried recording a macro, but it only repeats what I've done and doesn't continue for the rest of the people.
Thank you!
e.g. Data like this:
A B C D E
Name Score1 Score2 Score3 Score4
SAM 3 4 5 6
NICK 8 7 6 5
...
Thanks!
- Posts
-
4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020
768