Title pretty much sums it up.

I have a table with columns labeled Athlete Name, Test Date, Test and Test Result. I’ve made a small formatted area on another sheet that serves as a “data entry” form and I’m trying to figure out how to get the data to transfer to the bottom of the table (last empty row). There’s 10 possible tests I can type the name of and result in. So however many of those are filled, is like the name repeated in the name column that many times.

I’ve done this successfully before, however I’ve restructured the data table due to recommendations from the excel subreddit so it’s more “normalized”. This means a row is a single name, test and result. Then the name repeats for the next row with a different test name and result.

Due to this restructuring my VBA needs to change. I’m somewhat familiar with the .end(xlUp) to get the last row. What I’m stuck on is repeating the name X times in the name column based on the number of filled out test results in the “entry form”.

Would drawing from the CountA formula help here? If so, I can’t figure out how I’d go about that.

Any help is super appreciated. Happy to send the file too if it helps!

Ps. Stuck in an airport for a 5hr layover so this is my project for today