I believe this might be possible, but I don't know how to do it. I have 24
cells in a row. I want to limit the values that can go in the cell to single
digits (0 through 6). I also want it to move to the next cell to the right
once a single digit is entered. At the last cell. I want it to return to the
first cell in the next row. Can I do it and how?
Thanks!
Dan

I dont really understand, but looks like to need to validate the input
(datavalidation) and then have a macro triggerd on Worksheet_Change
to do the moving around.

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