I have now a input sheet with a Macro button that copies the input data into another worksheet.
the input sheet look like this:
Name: [ ]
Score (math): [ ]
score (art): [ ]
score(gym): [ ]
After the input and clicking a button, it now copies the input in one row: name, score (math), score (art), score(gym)
But I want a entry in three rows:
Name, Score, Course
XX , ##1 , math
XX , ##2 , art
XX , ##3 , gym
so, the macro need to copy the field Name three times, with the same value, and the numbers together with course names seperately into three rows.
in the following code cells F7,F8,F9 contains numbers and C7,C8,C9 are different criteria, C4,C5 are general text.
Please help. Thanks!
Please Login or Register to view this content.
Bookmarks