To help, I have a workplace climate survey with 24 questions. People select
one answer per question on a scale of 1-6. I use this workbook to add all the
responses (usually 250-500 depending on the department) and do the
calculations and charts. Evrything works fine, I'm just trying to limit the
keystrokes I am doing when entering the raw data from the surveys.

So survey #1 starts at cell B2 for question #1 and moves to cell C2 for
question 2, etc until cell Y2, where I want it to go to cell B3.

I sorta understand what you said, but can you be more specific?
Thanks!
Dan